Select the Cell


Then under Data Tab, in the Data Group, select "Text to Columns" and then follow the Wizard

The fact that splitting this into columns isnt working for this particular time stamp is the problem. I've tried doing using that capability in many ways and none will quite do the job. Problem arises because I have to split on a space delimiter (can't do fixed widths).

Basically I need a way to convert a text date to a number.

Hi there!
Here is a "corrected" solution, that i hope works.
Please check it out!

Note that there are three worksheets in the file!

Kind regards
Bjorn

Attached Files

DateTime NEW.xls (28.5 KB, 18 views)

Wow three great solutions...this works! Thanks Bjorn, I appreciate that.