Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Jos wrote...
I have an old spreadsheet in Windows that has the 1904 date format as basis. All my other spreadsheets are in the 1900 date format. Are there any utilities that can permanently convert a spreadsheet from the 1904 to the 1900 date format? There's no such thing as permanent conversion. I'm not aware of any utilities that would do this, but it's fairly easy to use a macro to do this. Basically, the macro would open a workbook, check if the workbook is using the 1904 date system, and if so change it to the 1900 date system and iterate through all used cells in all worksheets checking for cells containing constant dates (the cell's .HasFormula property would be FALSE while its .Value property would be type Date and have value 1), and when constant date values were found, add 1462 to them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
1900 vs 1904 date functions | Excel Worksheet Functions | |||
convert Excel sheet in 1904 format to 1900 without changing dates | Excel Worksheet Functions | |||
Date format in permanent list | Excel Discussion (Misc queries) | |||
Set Permanent Date Format to MM//DD/YYYY | Excel Discussion (Misc queries) | |||
Date format pre-1900. | Excel Discussion (Misc queries) |