changing a minus serial number into a date within Excel 2003

  • Thread starter Thread starter aussie1855
  • Start date Start date
A

aussie1855

I need to transfer some genealogical information into Excel 2003 but when i
transfer the dates any that are before 1900 are converted into minus serial
numbers. As i need to store the information in date format how can I change
the minus serial number into a date format
 
Hi,

Thanks for the information. I found that I could not get the link you
suggested to work but I found but I found this link

http://j-walk.com/ss/excel/files/xdate.htm

This has more information on more functions.

I have not try the work out suggested but will keep updates here.

Thanks for your assistance in this matter
 
Hi again,

Just to let people know that i eventually got the link given my Shane open
by going first to egghead.cafe.com then pasting the link into the address bar.

Have now tried the XDate function but could not get them to work and have
put up a querry on egghead for an answer.

Thanks to Shane for the help once again.

Michael
 
Back
Top