View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
DC Gringo
 
Posts: n/a
Default 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