number formatting
I want it to only display tenths, but the only number it shows is zero in the
tenths region. In other words if i put in: 0:52.3 on the pivot table it shows
0:52.0. The problem persisted after changing the format
"jaf" wrote:
Hi Alex,
You're telling Excel to round off the time to tenths of a second.
Try m:ss.000
It's the most decimal places Excel will display for time.
John
"Alex" wrote in message ...
I am trying to enter swimming race times in excel. I am using the format:
m:ss.0, but when i put the data into a pivot table all of the tenths become
zeros.
HELP
|