Text to date????

[Graham Feeley]

Is it possible to change a field from text as in 18Feb2000 to a formatted
date field ????
I got about 5000 records that needs changing
any help appreciated
Regards
Graham

 

[JohnI in Brisbane]

Graham,

Use the following formula, where your date is in A2-

=DATEVALUE(A2)

and format the cell in your required date format.

Then "Copy", "Paste Special - Values" to get rid of the formula afterwards
if you need.

regards,

JohnI

 

[Dave Peterson]

And if they're all in one column, you could:

Select your column
Data|Text to columns
Fixed width
Advance to the step that prompts you for Column data Format
Choose dmy
and finish up.

Then give it the format you want.

 

[Jean Ruch]

Is it possible to change a field from text as in 18Feb2000 to a formatted
date field ????
I got about 5000 records that needs changing
any help appreciated
Regards
Graham

Hello Graham,

Suppose your Data in A1
in B1 write = A1*1
and format as you want (for example TT MM JJJJ)
Fill Down to B 5000

regards

Jean

 

[Jean Ruch]

Suppose your Data in A1
in B1 write = A1*1
and format as you want (for example TT MM JJJJ)

Hello Graham,

In your country, mdy would be better !
sorry for this.

Jean