Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Dates
I am copying dates from a website formatted in MMM-DD (e.g. Sep-12).
However, when I copy the dates into excel, it reads it as DD-MM (e.g. Sep-12 is copied as Dec-09). If I copy dates which cannot be transposed (such as Oct-16) then it copies correctly as Oct-16. Is there a way to a) Copy the native dates into excel (e.g. Sept-12 as Sept-12) b) Copy dates such that Excel does not interpret them as dates (e.g. Sept-12 is "Sept-12" not 09/12/2007 in the formula bar) c) Easily transpose month and day (e.g. convert Dec-09 to Sept-12) Thanks, Noah |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Dates
Noah
You have a few things at play here. If Excel 'converts' the dates then it will take your locale settings as in Windows. The 'dates' that are not converting, are being seen as text by Excel, not dates. You might want to consider using the DataGet external dataNew web query as a route to do this. When you take this route, just navigate to the web page, click the table(s) you want to bring in and then under 'options' in the browser dialog (top right I think), you can disable Excel's conversion of dates. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk web: www.excelusergroup.org "Noah" wrote in message ... I am copying dates from a website formatted in MMM-DD (e.g. Sep-12). However, when I copy the dates into excel, it reads it as DD-MM (e.g. Sep-12 is copied as Dec-09). If I copy dates which cannot be transposed (such as Oct-16) then it copies correctly as Oct-16. Is there a way to a) Copy the native dates into excel (e.g. Sept-12 as Sept-12) b) Copy dates such that Excel does not interpret them as dates (e.g. Sept-12 is "Sept-12" not 09/12/2007 in the formula bar) c) Easily transpose month and day (e.g. convert Dec-09 to Sept-12) Thanks, Noah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When copying dates, they change by 4 yrs & 1 day, why? | Excel Worksheet Functions | |||
Problem copying dates | Excel Discussion (Misc queries) | |||
Copying Dates | Excel Discussion (Misc queries) | |||
Copying groups of dates | Excel Discussion (Misc queries) | |||
When copying dates to another sheet the dates are different | Excel Worksheet Functions |