Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I use Excel extensively for my genealogy which uses pre-1900 years. It is a
real problem that MS can not provide an add-in for xdate rather than having to purchase PUP 6.0. However, my problem is that I created a spreadsheet under MS Office 97 where an Exhibit ID is YYYY.MM.DD ... but, when my new MS Office Excel 2003 opens the file it changes the format and I can not re-format it to the YYYY.MM.DD format accurately. Since this spreadsheet was my Index, it is critical that I have the original, accurate Exhibit ID. How can I do this? I have a backup of the original file if I can figure out what I need to do to the Excel template / addins before opening the old version. Bonita |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Formatting Problem | Excel Discussion (Misc queries) | |||
Date sorting problem | Excel Discussion (Misc queries) | |||
Time Date Formula Problem | Excel Worksheet Functions | |||
Login Logout Date Problem | Excel Worksheet Functions | |||
Date and Time Picker Control problem | Excel Discussion (Misc queries) |