Convering String to Date

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

Does anyone know if it is possible to change the 26FEB04
into a date format. I have tried changing the Number
Format to date but this is not working.

TIA
 
One way:

Choose Data/Text to columns, click Next, Next, then select the Date in
the appropriate format from the dropdown. Click Finish.
 
Hi Edgar!

Select an empty cell
Copy
Select the cells with this format
Edit > Paste Special > Add > OK
Format the resulting number as a date.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top