LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default all cells in 2 workbooks have automaticlly changed to date format

Why would excel 2007 automaticly change formats?

Upon opening a workbook this morning all the blank cells in the 16 sheets
had changed from general format to date format, and 99.9% of cells with data
or formulas were also changed to the date format.
I opened another workbook and it was find, I closed it and reopened it and
the same thing occurred, most cells had been changed to the date format.
The first wb containts payroll data, with mostly sumifs functions and was
working fine yesturday. The second wb contains data using vlookup and if
functions.

Thank you
Deb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
General Text format automatically get changed to DATE Shweta Srivastava[_2_] Excel Discussion (Misc queries) 0 September 21st 09 10:57 AM
custom date format changed in mail merge olrustyxlsuser Excel Discussion (Misc queries) 10 June 7th 07 05:25 PM
My Auto Sum Function is not Automaticlly summing the cells Christie Excel Worksheet Functions 1 November 7th 06 01:46 AM
Date column changed to number format while concatenating Biju Jacob Excel Discussion (Misc queries) 1 June 12th 06 07:07 PM
Exporting Data to Excel-Date Format Changed Nick B Excel Discussion (Misc queries) 3 May 3rd 05 12:43 PM


All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"