Need to double-click for data to be recognised as date?!
 

Hi there,
I've seen several similar problems but never any solutions.
I import a lot of data with a date in the format "yyyymmdd" and Excel
2000 does not recognise this as a date.
So I used LEFT, RIGHT and CONCATENATE to end up with "dd/mm/yyyy". But
even when I paste special as value this does not get recognised as a
date. Only when I double-click into such a cell and leave it again does
Excel finally recognise it. Since the list is over a thousand lines
long, I don't want to double-click each cell individually.
I tried:
- format painter
- paste special -- format (from another cell that WAS recognised as
date)
- paste special -- value (the "concatenated" data, into a cell that was
formatted as date)

None of that worked. HELP!! ( :confused: ) Thanks!


--
HierkommtdieMau
------------------------------------------------------------------------
HierkommtdieMau's Profile: http://www.excelforum.com/member.php...o&userid=32867
View this thread: http://www.excelforum.com/showthread...hreadid=527053

Need to double-click for data to be recognised as date?!
 

Hi

Try copying a blank unused cell, selecting your range of 'dates' and then
Edit/Paste Special/Add.
Make sure you take a copy before you start!

Andy.

"HierkommtdieMau"
<HierkommtdieMau.25dfby_1143534601.0239@excelfor um-nospam.com wrote in
message news:HierkommtdieMau.25dfby_1143534601.0239@excelf orum-nospam.com...

Hi there,
I've seen several similar problems but never any solutions.
I import a lot of data with a date in the format "yyyymmdd" and Excel
2000 does not recognise this as a date.
So I used LEFT, RIGHT and CONCATENATE to end up with "dd/mm/yyyy". But
even when I paste special as value this does not get recognised as a
date. Only when I double-click into such a cell and leave it again does
Excel finally recognise it. Since the list is over a thousand lines
long, I don't want to double-click each cell individually.
I tried:
- format painter
- paste special -- format (from another cell that WAS recognised as
date)
- paste special -- value (the "concatenated" data, into a cell that was
formatted as date)

None of that worked. HELP!! ( :confused: ) Thanks!


--
HierkommtdieMau
------------------------------------------------------------------------
HierkommtdieMau's Profile:
http://www.excelforum.com/member.php...o&userid=32867
View this thread: http://www.excelforum.com/showthread...hreadid=527053

Need to double-click for data to be recognised as date?!
 

Thanks a lot Andy - that did the trick !! *hooray!*


--
HierkommtdieMau
------------------------------------------------------------------------
HierkommtdieMau's Profile: http://www.excelforum.com/member.php...o&userid=32867
View this thread: http://www.excelforum.com/showthread...hreadid=527053

Need to double-click for data to be recognised as date?!
 

Thanks for the feedback!

Andy.

"HierkommtdieMau"
<HierkommtdieMau.25dj9n_1143539702.0797@excelfor um-nospam.com wrote in
message news:HierkommtdieMau.25dj9n_1143539702.0797@excelf orum-nospam.com...

Thanks a lot Andy - that did the trick !! *hooray!*


--
HierkommtdieMau
------------------------------------------------------------------------
HierkommtdieMau's Profile:
http://www.excelforum.com/member.php...o&userid=32867
View this thread: http://www.excelforum.com/showthread...hreadid=527053