Change text to date

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

Gerrym

I have a column of cells with dates stored as text i.e.
041012 and I would like to convert this to 12/10/04
(dd/mm/yy) how do I do this, please
 
Hi

Select the cells. Go menu Data > Text to columns. Go "Next" until you're in
the wizard's part 3, there select format Date, MDY (or DMY is that's what
you have) and click Finish.

HTH. Best wishes Harald
 
Hi. Assuming the text is in "A1", try this in "B1",
=RIGHT(A1,2)&"/"&MID(A1,3,2)&"/"&LEFT(A1,2). You end up with a date, but u
may have to copy and paste it special to get rid of the formulas.
 
You must log in or register to reply here.

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

Similar Threads

Formatting date as first letter of day only 33
Vba Date$ 1
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? 4
convert first 6 digits into date 22
Date formatting 1
Finding Date in an overseas format 20
Date conversion question 6
Pasting a date to a cell from UserForm 2

Back
Top