One way:

=DATEVALUE(A1)

Format as DATE

Biff

"carl" wrote in message
...
I have text vlaues that are like this:

Aug1
Aug10
Aug11
Aug14
Aug15
Aug16
Aug17
Aug18

Is there a way to convert these to actual dates ?


Thank you in advance.