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!! ( ) Thanks!


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