View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Olly
 
Posts: n/a
Default Custom Number Format

Am trying to custom format a field in a pivot table. I want to display the
decimal point and 2 decimal places, unless the value is an integer.

With format '0.??' I achieve what I want with the decimal places. But then
all integer values still display the decimal point. How do I remove this?


Olly