Date pasted web site causing inconsistent date format

[lilhoot]

Ref: Excel 2003 - Can anyone tell me how to fix and why dates pasted into a
cell from a website would caused inconsistent date format? I formatted my
dates to be like 3/14/2008. For example, I am copying about 750 records from
my company website and pasting them into an excel worksheet. The websites
date format is like 01/09/2008. The first 109 records pasted into Excel
worked as I wanted to be formatted, but the rest have the websites format
(i.e.01/09/2008). Changing it in Format/Cells doesn't work.

Any help will be greatly Appreciated.

Thanks

 

[Sean Timmons]

Try putting 1 in a blank cell.

Then copy the 1, highlight your date column, paste special/multiply. Should
change to current format.

It's probably bringing the date in as a non-number and formatting cells
won't make it work for you.

 

[lilhoot]

David,

The Data/Text to Columns worked! No changes to Regional options. Oh, the
date is January 9, 2008.

Thank you very much!

01/09/2008 is an ambiguous description of a date. Do you mean 1st Sep or
9th Jan?

Did your input format match the format shown in Windows Control Panel/
Regional Options? [Because it is that setting which governs interpretation
of *inputs* to Excel, whereas the Excel format cells option governs only how
a date stored in Excel is *displayed*]

It might be worth trying to see whether Data/ Text to Columns will sort out
your data. At the last stage of the wizard you'll need to tell it the
format of your date input.
--
David Biddulph

Ref: Excel 2003 - Can anyone tell me how to fix and why dates pasted into
a
cell from a website would caused inconsistent date format? I formatted my
dates to be like 3/14/2008. For example, I am copying about 750 records
from
my company website and pasting them into an excel worksheet. The websites
date format is like 01/09/2008. The first 109 records pasted into Excel
worked as I wanted to be formatted, but the rest have the websites format
(i.e.01/09/2008). Changing it in Format/Cells doesn't work.

Any help will be greatly Appreciated.

Thanks