Converting Dates
Try this:
=DATE(LEFT(A1,1)+2000,MID(A1,2,2),RIGHT(A1,2))
"Jacq" wrote:
I have a bunch of numbers on an excel file that are this format: 70220. I
would like to convert them to a regular date. I tried just formatting the
cells to dates, but it does not work. It should be 2/20/07. Can anyone help?
Thanks.
|