Alan,

Here's a formula to convert an Excel serial number (date value) to a text
representation:
=TEXT(YEAR(B1),0)&"/"&TEXT(MONTH(B1),0)&"/"&TEXT(DAY(B1),0)

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
icon.
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.

Bill

----- 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 @yahoo.com address at http://mail.yahoo.com



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2022 by midrange.com 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.