I'm trying to set up a pivot table, the data in the
worksheet is custom and in the format of m:ss.00. This
displays correct in the cell, however in the data in the
formula bar shows it as hh:mm:ss and the hundreths of a
second have been rounded up to the nearest second. This
is also repeated in the cell in the pivot table. does
anyone know how to change this to display hundreths of a
second