Thread: My pivot tables seem to save with cells 'time format'

I have a workbook with a number of pivot tables that I update daily. Whenever I open the workbook all number formats have changed from number wit no decimal places to an hh:mm:ss format always set to 00:00:00 I have to reset all columns every time and I'd rather not !

What format have you set? I personally use a custom format (brackets for negative), in part because that means that the last (right) digit is not bang-up against the right margin of the cell. If you have been using the default number format or general format, try setting a specific format such as:

#,##0_);[Red](#,##0)

In this case, negative numbers are shown in red as (2) rather than, say, -2 ... accountants prefer this format because the "-" sign is easy to miss and brackets around a number are very explicit.

Or, if you prefer, try:

#,##0;[Red]-#,##0

... if you don't like brackets around negative numbers.

I suspect that if you specify a custom format, your problem will go away.

HTH