how can these date be converted from text to numbers

[anon125]

I still use excel 2002 with xls files.
see attached


assume 2017 to 2018
thanks all

 

[anon125]

value, date value, to columns etc did not work.
maybe i can add a year? concatenate?
thanks all

 

[alansidman]

How do we know which dates apply to 2017 or 2018?

 

[anon125]

they are in order. 2017 then after dec in 2018.
thanks

 

[alansidman]

There are no dates after December in your file. Perhaps you are not showing us enough data.

 

[anon125]

i can post the whole file if you like!
but i doubt it is needed!
looks like some are text and some are numbers!

 

[alansidman]

10-15 records that are representative of your actual file covering the two years.

 

[alansidman]

Highlight the range of data in column B.
Data-->Text to Columns
Next-->Next
Select Date
Change the Lookup to DMY
Click on Finish.

It has been a very long time since I used XL2002. I do not remember the layout of the menus. This is the best I can do for you unless you have a more current version of excel available. Your software is over 20 years old and this feature may not be available to you.

 

[anon125]

did that before i posted.
thanks for trying

 

[anon125]

problem now solved

 

[AliGW]

What was the solution?

 

[anon125]

someone elses secret!

 

[AliGW]

It is expected that you share the solution, as this is a community and it might benefit someone else in future. Please explain how you solved the issue. Thank you.

 

[anon125]

as i wrote...someone elses secret!

 

[alansidman]

Truly unfortunate. You come here asking for help, but are unwilling to offer any. I know who is now on my "do not help list" in the future. Good Luck.

 

[anon125]

spite is so ugly

 

[AliGW]

You have refused my request twice, and disrespected another member who had helped you, so as you are unwilling to behave in a way that matches our community spirit, I have banned you.