date conversion after pasting
I am pasting two columns into Excel...the first is supposed to be a date and
is in format YYYYMMDD, the second a simple integer...here's an example:
Date, Value
--------------------
20050120, 5
20051105, 6
20060213, 4
Each time I copy it into Excel and try to format it as a date, it gives me
only "############"
How can I convert this to show and act like a date so I can chart with it?
_____
DC G
|