Excel 2007 : all format in cells and worksheets changed to TIME format?

**[email protected]** · 02-22-2010, 10:58 AM

I currently have a spreadsheet with mutliple worksheets. We noticed that the formatting for all cells changed to TIME format even though the cells might have been DATE, NUMERIC, or just GENERAL. Our user says they did not change the formatting. Wondering if any EXCEL 2007 does an automatic update that I am not aware of??? We are starting to use 2007 and not has familiar. Any thoughts are appreciated.

**[email protected]** · 02-22-2010, 01:29 PM

How do I cancel this request.

**jeffreybrown** · 02-22-2010, 01:38 PM

You marked it solved that will do

**mwalsh007** · 01-09-2012, 01:39 PM

how did you solve this?

Originally Posted by [email protected]

I currently have a spreadsheet with mutliple worksheets. We noticed that the formatting for all cells changed to TIME format even though the cells might have been DATE, NUMERIC, or just GENERAL. Our user says they did not change the formatting. Wondering if any EXCEL 2007 does an automatic update that I am not aware of??? We are starting to use 2007 and not has familiar. Any thoughts are appreciated.