View Single Post
  #1   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

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.