The problem I have is that I have a worksheet with data as time, formatted
as m:ss.00 were 00 is hundredths of a second. I have noticed that the cell
shows the correct time say 1:34.96 but the formula bar shows it as rounded
up 1:35 this is also carried to the pivot table. so my data for printing is
wrong. Has anyone got an idea how I can over come this problem. thanks Gerry