Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
General Text format automatically get changed to DATE | Excel Discussion (Misc queries) | |||
custom date format changed in mail merge | Excel Discussion (Misc queries) | |||
My Auto Sum Function is not Automaticlly summing the cells | Excel Worksheet Functions | |||
Date column changed to number format while concatenating | Excel Discussion (Misc queries) | |||
Exporting Data to Excel-Date Format Changed | Excel Discussion (Misc queries) |