more date conversions

J

JulieD

Hi Neville,

not sure if this is part of a continuing conversation, but as you don't
mention one in your post i'll assume you simply have a cell with the number
10000104 entered and you want to convert it to a date. If so, this can be
done by placing the following formula in an adjacent cell
=DATE(2000,MID(A1,4,2),RIGHT(A1,2))
where A1 is the reference of your number.
you can then copy & edit / paste special - values the result of this over
the original data if required

Cheers
JulieD
 
N

Neville

now i have a date entered as 1000104 which I want as to be 04/01/2000, any
suggestions? thanks.
 
Top