View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Roee Roee is offline
external usenet poster
 
Posts: 6
Default 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.