software

Hi there,
I've seen several similar problems but never any solutions.
I import a lot of data with a date in the format quot;yyyymmddquot; and Excel
2000 does not recognise this as a date.
So I used LEFT, RIGHT and CONCATENATE to end up with quot;dd/mm/yyyyquot;. 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 quot;concatenatedquot; data, into a cell that was
formatted as date)

None of that worked. HELP!! ( ) Thanks!--
HierkommtdieMau
------------------------------------------------------------------------
HierkommtdieMau's Profile: www.excelforum.com/member.php...oamp;userid=32867
View this thread: www.excelforum.com/showthread...hreadid=527053Hi

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.

quot;HierkommtdieMauquot;
lt;HierkommtdieMau.25dfby_1143534601.0239@excelfor um-nospam.comgt; wrote in
message news:HierkommtdieMau.25dfby_1143534601.0239@excelf orum-nospam.com...
gt;
gt; Hi there,
gt; I've seen several similar problems but never any solutions.
gt; I import a lot of data with a date in the format quot;yyyymmddquot; and Excel
gt; 2000 does not recognise this as a date.
gt; So I used LEFT, RIGHT and CONCATENATE to end up with quot;dd/mm/yyyyquot;. But
gt; even when I paste special as value this does not get recognised as a
gt; date. Only when I double-click into such a cell and leave it again does
gt; Excel finally recognise it. Since the list is over a thousand lines
gt; long, I don't want to double-click each cell individually.
gt; I tried:
gt; - format painter
gt; - paste special -- format (from another cell that WAS recognised as
gt; date)
gt; - paste special -- value (the quot;concatenatedquot; data, into a cell that was
gt; formatted as date)
gt;
gt; None of that worked. HELP!! ( ) Thanks!
gt;
gt;
gt; --
gt; HierkommtdieMau
gt; ------------------------------------------------------------------------
gt; HierkommtdieMau's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32867
gt; View this thread: www.excelforum.com/showthread...hreadid=527053
gt;

Thanks a lot Andy - that did the trick !! *hooray!*--
HierkommtdieMau
------------------------------------------------------------------------
HierkommtdieMau's Profile: www.excelforum.com/member.php...oamp;userid=32867
View this thread: www.excelforum.com/showthread...hreadid=527053Thanks for the feedback!

Andy.

quot;HierkommtdieMauquot;
lt;HierkommtdieMau.25dj9n_1143539702.0797@excelfor um-nospam.comgt; wrote in
message news:HierkommtdieMau.25dj9n_1143539702.0797@excelf orum-nospam.com...
gt;
gt; Thanks a lot Andy - that did the trick !! *hooray!*
gt;
gt;
gt; --
gt; HierkommtdieMau
gt; ------------------------------------------------------------------------
gt; HierkommtdieMau's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32867
gt; View this thread: www.excelforum.com/showthread...hreadid=527053
gt;