View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Recognizing 2-digit years

Maybe you can
select that range (column?)
edit|Replace
what: (spacebar)
with: (leave blank)
replace all

or even select that column (one column at a time)
data|text to columns


Dallman Ross wrote:

In , Dallman Ross <dman@localhost.
spake thusly:

My problem is, the entry M/dd/yy in the CSV file seems to
Excel to be a non-date string. I have formatted the column
for dates -- that makes no difference.


Oh, brother; I see. The jerks inserted a blank space in front now
in all the columns in the CSV file. I'm not sure yet what the best
way to handle this is -- I'm not wanting to massage the data I
download and import.

Dallman


--

Dave Peterson