But I want it to show decimal parts *if they exists*.
I want to see 1000.05 as 1,000.05 (and not 1,000 or 1000.05) and 1,000 as
1,000 (and not 1,000.00).

Using a fixed 0 decimal places or a format of #,##0 does not allow it.

Any suggestions?

Thanks,
Roee.

"Bob Phillips" wrote:

Use a format of #,##0.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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.