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

H

HierkommtdieMau

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!
 
G

Guest

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell format - not automatically taking effect 4
After concatenating data, how do I get Excel to recognise date? 9
Excel 2002: How to make the date format uniform ? 1
data turned in date format when copied 2
Date Format Not Responding to MM/DD/YY 2
Reformating large amount of data 2
Excel date format YYYYMMDD 1
Problem sorting by date after 2029 on Excel 2003 1

Top