Change General format to Date format


V

Vic

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 #############.
 
Ad

Advertisements

F

Francis

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
 
Ad

Advertisements

J

Jacob Skaria

You can try the below to convert the entire column at a stretch.

Select the column.
From Data menu select 'Text-to-Columns' option...
Hit Next...Next will take you to Step 3 of the Wizard
Select Column data format as 'Date'
Select the format in which your data is (YMD)
Hit Finish.

Excel now converts all the text dates to the date format.

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top