Text to date????

  • Thread starter Thread starter Graham Feeley
  • Start date Start date
G

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
 
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
 
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.
 
Graham Feeley said:
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
Click to expand...

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 said:
Suppose your Data in A1
in B1 write = A1*1
and format as you want (for example TT MM JJJJ)
Click to expand...

Hello Graham,

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

Jean
 
Back
Top