DOH!
My mistake. I thought the OP wanted to separate the
numeric value and convert to date/time format.
Biff
-----Original Message-----
Hmm...I don't see a decimal point in the OP's "14/04/03
14:20".
What version of XL are you using. My solution works fine
in XL03 and
XL04.
If the date is not in your date format (i.e., if it's dmy
and you use
mdy), to to the third pane of the Text to Columnyou can
select first
column in the third pane and choose the dmy option from
the Date
dropdown. That will coerce what the parser would see as a
text value to
a date.
In article ,
"Biff" wrote:
That's not working for me. Not working means nothing
happens.
What does work is T to C.
Fixed width
Place the delimiter before the decimal point.
Still have to manually format as desired.
Couldn't come up with a formula solution that's really
much better than what the OP is already doing.
.
|