Thread: permanent conversion of 1904 date format to 1900 date format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default permanent conversion of 1904 date format to 1900 date format
I don't know of any utilities but subtracting 1462 from each 1904 date will
give you a 1900 date.

Helper column with =A1-1462 will convert.

Or enter 1462 in an unused cell.

Copy that cell then select the range of date cells and Paste
SpecialSubtractOKEsc.


Gord Dibben MS Excel MVP

On Mon, 20 Jul 2009 16:32:05 -0700, 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?

Reply With QuoteReply With Quote