![]() |
Pivot Table
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 |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com