Here's a formula to convert an Excel serial number (date value) to a text

Here's how to test that it works:
In Cell A1 enter       =DATE(2001,12,11)
In Cell B1 enter       =DATE(2001,12,11)
Both cells will show     12/11/01  (depending upon your PC's date format).
Now, click on B1 and Format/Cells/Number  -or- click on the comma "," tool bar
Even though B1 has the same value as A1, it shows 37,236; the serial number for
that date.
Now, enter the formula specified above into C1 and you have now created a text
value of that serial date.


----- Original Message -----
> columns they are sending are date fields.  I guess there must be
> documentation on how to convert that Excel number to a date but I was hoping
> IBM or someone else had done it for me :)

Do You Yahoo!?
Get your free address at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.