Date format

Posted by Joyce on May 16, 2001 10:15 AM

I have a file that, when opened in Excel, shows the date as 43001 for April 30, 2001. I there a way to change this to 30/04/2001?

Thanks,

Joyce

Posted by Kevin James on May 16, 2001 10:24 AM

Joyce ,

From the menu bar: Format / Cells.

In the dialog box, choose Date. In the right panel choose the date format.

Kevin

Posted by Mark W. on May 16, 2001 10:36 AM

Joyce, looks like your "date" value is an integer
representation in "mmddyy" format, but the leading
zero has been trimmed (perhaps, during import).
The following formula can be used to calculate
the proper internal date value which then can be
formatted as you wish...

=DATE(2000+RIGHT(A1,2),LEFT(A1,LEN(A1)-6+2)+0,MID(A1,3+LEN(A1)-6,2)+0)

P.S.: I trust that all your dates are in this century.
If not, the 1st argument to the DATE() function will
need to be revised.

Posted by Joyce on May 17, 2001 7:38 AM

Thanks!

Thanks for the help. Mark's formula did the trick.

Joyce