| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date conversion issue
I have copied a file from another computer to Excel in CSV format. the source
computer has the date in the format 07/11/13 (it's actually 2007/11/13) and it is displaying in Excel as 7/11/2013. If I go into Excel and change the format of the cell to yyyy/mm/dd format it changes it to 2013/07/11 which is still wrong. How do I get 7/11/13 to display as 2007/11/13 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion issue
Because its CSV, Excel "thinks" it knows how to interpret the value. Just
rename the file to something other than CSV. This will casue the Import Wizard to be invoked. You can then tell the Wizard how to interpret the value correctly. -- Gary''s Student - gsnu200761 "GKW in GA" wrote: I have copied a file from another computer to Excel in CSV format. the source computer has the date in the format 07/11/13 (it's actually 2007/11/13) and it is displaying in Excel as 7/11/2013. If I go into Excel and change the format of the cell to yyyy/mm/dd format it changes it to 2013/07/11 which is still wrong. How do I get 7/11/13 to display as 2007/11/13 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion issue
Another way of invoking the wizard, without renaming the file, is to use
Data/ Import External Data, from within Excel, rather than just opening the CSV file. -- David Biddulph "Gary''s Student" wrote in message ... Because its CSV, Excel "thinks" it knows how to interpret the value. Just rename the file to something other than CSV. This will casue the Import Wizard to be invoked. You can then tell the Wizard how to interpret the value correctly. -- Gary''s Student - gsnu200761 "GKW in GA" wrote: I have copied a file from another computer to Excel in CSV format. the source computer has the date in the format 07/11/13 (it's actually 2007/11/13) and it is displaying in Excel as 7/11/2013. If I go into Excel and change the format of the cell to yyyy/mm/dd format it changes it to 2013/07/11 which is still wrong. How do I get 7/11/13 to display as 2007/11/13 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion issue
could you be more specific in listing the steps to do this
thanks "GKW in GA" wrote: I have copied a file from another computer to Excel in CSV format. the source computer has the date in the format 07/11/13 (it's actually 2007/11/13) and it is displaying in Excel as 7/11/2013. If I go into Excel and change the format of the cell to yyyy/mm/dd format it changes it to 2013/07/11 which is still wrong. How do I get 7/11/13 to display as 2007/11/13 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| '03 UDF conversion to '07 encryption issue | Excel Worksheet Functions | |||
| XML to Excel conversion issue | Excel Discussion (Misc queries) | |||
| Vlookup text conversion issue | Excel Discussion (Misc queries) | |||
| Date conversion issue... again | Excel Discussion (Misc queries) | |||
| Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
Linear Mode
