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
|