Thread
:
Using 1000 sperator without specifying decimal places
View Single Post
#
9
Posted to microsoft.public.excel.misc
Roee
external usenet poster
Posts: 6
Using 1000 sperator without specifying decimal places
Thanks, it works - only now 1000 it shows "1,000." with a dot at the end even
if there aren't any numbers after it.
Is my request so wierd that it does not exists in Excel as a proper option??
"Sandy Mann" wrote:
Roee,
Try something like a custom format of #,##0.######
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Roee" wrote in message
...
Hello,
I would like to use the 1000 sperator but I don't want to specify fixed
decimal places.
For example, if the cell contains the number 300, I want it to show 300
and
not 300.00, but I still wan't to use the 1000 sperator.
How do I do that?
The "General" formatting showes the decimal places like I want (only if
exists) but does not allow 1000 sperator and the "Number" formatting
requires
defining a fixed number of decimal places.
Thanks,
Roee.
Reply With Quote
Roee
View Public Profile
Find all posts by Roee