date in text format as a real date

M

Mortir

I have a date that is in text format 12.01.08 (dd.mm.yy). However I
cant convert it to a real date which can be used for further
operations. The format cell - date does not work... Thanks for your
help
 
M

Mike H

Try

Select your date then

data|text to columns
Select fixed width
Next
Next
Select date D/M/Y
Finish

Mike
 
G

Gord Dibben

Data>Text to Columns>Next>Next>Column Data Format>Date>DMY and Finish.


Gord Dibben MS Excel MVP
 

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 do I sort in English Date format 2
Convert dates 3
countifs criteria includes date range 4
Date format problems after csv import 2
Converting text format of time/date into Excel time/date for subtr 5
Special string convertion to date and time 4
Date Format 9
Date format diplays incorrectly 1

Top