Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Date changes when copied and pasted | Excel Discussion (Misc queries) | |||
Date formatting inconsistent | Excel Worksheet Functions | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |