Convert a text in a date format

  • Thread starter Thread starter xBeckx
  • Start date Start date
X

xBeckx

Hi
I have imported a file where there is a field that is suposed to contain a
date. It was transformed in text, like 22FEB2010. I need to treat this field
as date. How can i transform it in a date format?
Tks
 
xBeckx said:
Hi
I have imported a file where there is a field that is suposed to contain a
date. It was transformed in text, like 22FEB2010. I need to treat this field
as date. How can i transform it in a date format?
Tks
Click to expand...

Copy a blank cell. Select your "dates". Edit / Paste Special / Values / Add /
OK. Result will be a 5 digit number. Select date format as desired.
 
Another method.

Data>Text to Columns>Finish.


Gord Dibben MS Excel MVP
 
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

How can I migrate MBOX to PST? 2
Which is the best MBOX Converter Tool different formats conversion? 4
Date format problems after csv import 2
How do i convert dates to text but keep the date format 1
Windows 7 I need to convert date to text 3
Need help with converting CUSTOM format/TEXT format to DATE format 6
Converting text format of time/date into Excel time/date for subtr 5
Dates 3

Back
Top