Date problem (YYYY.MM.DD)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
If you have a cell with a date in it, then select the cell and :

Format > Cell > Custon > and enter yyyy.mm.dd

this will make 12/25/2005 appear as 2005.12.25
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

write date into file in YYYY.MM.DD format 5
Divide Date Time Stamp 5
Help with XDATE function add-in 3
permanent conversion of 1904 date format to 1900 date format 3
How do I format an Excel date earlier than 1900? 1
Formula to show date, i.e., Apr.01-31.2007? 2
Microsoft Works to Microsoft Office 6
Dates prior to 1900 2

Back
Top