LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LadyBonita
 
Posts: n/a
Default Date problem (YYYY.MM.DD)

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
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
Date Formatting Problem Jocko69 Excel Discussion (Misc queries) 3 November 6th 05 06:59 PM
Date sorting problem Ardell Excel Discussion (Misc queries) 1 November 4th 05 05:46 PM
Time Date Formula Problem Oowf Excel Worksheet Functions 2 June 1st 05 06:01 PM
Login Logout Date Problem ascool_asice Excel Worksheet Functions 2 May 30th 05 12:50 AM
Date and Time Picker Control problem Andy Tallent Excel Discussion (Misc queries) 0 May 4th 05 12:50 PM


All times are GMT +1. The time now is 05:04 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"