Thread: Number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Olsen
 
Posts: n/a
Default Number format

Could someone tell me if this is possible and how to do it if it is in using
the custom number formats in Excel. I want to have thousands separators in
my number. I know how to add this but my problem is that if there is no
decimal part of the number then I dont want the decimal point to appear. If
there is a decimal part then I want the decimal point involved. It would be
even better if I could have it do 2 digits of precision if there is a decimal
part but that is not totally necessary.

For Example

8300
8300.25
8300.20
754

Thanks,

Mark