Date pasted web site causing inconsistent date format
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 |
Date pasted web site causing inconsistent date format
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 "lilhoot" wrote in message ... 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 |
Date pasted web site causing inconsistent date format
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" wrote: 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 |
Date pasted web site causing inconsistent date format
David,
The Data/Text to Columns worked! No changes to Regional options. Oh, the date is January 9, 2008. Thank you very much! "David Biddulph" wrote: 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 "lilhoot" wrote in message ... 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 |
All times are GMT +1. The time now is 08:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com