Change General format to Date format
Hi try this in an adjacent cell and copy down
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
this assume that you will also have value such as : 20090501 for
1st May 2009
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"Vic" wrote:
I have 20061030 in a cell that is formatted as general. How do I change this
into date format like 10/30/2006? If I format cell and select date then it
gives me #############.
|