| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
when I import month and day get flipped
When I import a date from an external source, my date month and day get
flipped unless the day is greater than 12 then it reverts to text. Any suggestions on what to do? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I import month and day get flipped
Be sure to use the Import Wizard when you import the data. You can tell the
Wizard what the format is. -- Gary''s Student - gsnu200836 "Kristi" wrote: When I import a date from an external source, my date month and day get flipped unless the day is greater than 12 then it reverts to text. Any suggestions on what to do? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I import month and day get flipped
When I export from one system it opens a version of excel, regardless of if i
copy and paste from that excel version or if I import from that version that date gets flipped Ex 03/02/2009 gets changed to 2/3/2009 "Gary''s Student" wrote: Be sure to use the Import Wizard when you import the data. You can tell the Wizard what the format is. -- Gary''s Student - gsnu200836 "Kristi" wrote: When I import a date from an external source, my date month and day get flipped unless the day is greater than 12 then it reverts to text. Any suggestions on what to do? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I import month and day get flipped
You need to make the Wizard appear. Export from your app as either .csv or
..txt Then open Excel and: Data Import External Data Import Data... and point to the .txt file This forces the Wizard to appear. Tell the Wizard that the field is: mm/dd/yyyy -- Gary''s Student - gsnu200836 "Kristi" wrote: When I export from one system it opens a version of excel, regardless of if i copy and paste from that excel version or if I import from that version that date gets flipped Ex 03/02/2009 gets changed to 2/3/2009 "Gary''s Student" wrote: Be sure to use the Import Wizard when you import the data. You can tell the Wizard what the format is. -- Gary''s Student - gsnu200836 "Kristi" wrote: When I import a date from an external source, my date month and day get flipped unless the day is greater than 12 then it reverts to text. Any suggestions on what to do? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I import month and day get flipped
The option of exporting from the origional source as .txt or .csv is not
available the only options are export to word or export to excel "Gary''s Student" wrote: You need to make the Wizard appear. Export from your app as either .csv or .txt Then open Excel and: Data Import External Data Import Data... and point to the .txt file This forces the Wizard to appear. Tell the Wizard that the field is: mm/dd/yyyy -- Gary''s Student - gsnu200836 "Kristi" wrote: When I export from one system it opens a version of excel, regardless of if i copy and paste from that excel version or if I import from that version that date gets flipped Ex 03/02/2009 gets changed to 2/3/2009 "Gary''s Student" wrote: Be sure to use the Import Wizard when you import the data. You can tell the Wizard what the format is. -- Gary''s Student - gsnu200836 "Kristi" wrote: When I import a date from an external source, my date month and day get flipped unless the day is greater than 12 then it reverts to text. Any suggestions on what to do? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I import month and day get flipped
So export to Word, then save as text.
Your other option may be to change your Windows regional settings, in Control Panel. -- David Biddulph "Kristi" wrote in message ... The option of exporting from the origional source as .txt or .csv is not available the only options are export to word or export to excel "Gary''s Student" wrote: You need to make the Wizard appear. Export from your app as either .csv or .txt Then open Excel and: Data Import External Data Import Data... and point to the .txt file This forces the Wizard to appear. Tell the Wizard that the field is: mm/dd/yyyy -- Gary''s Student - gsnu200836 "Kristi" wrote: When I export from one system it opens a version of excel, regardless of if i copy and paste from that excel version or if I import from that version that date gets flipped Ex 03/02/2009 gets changed to 2/3/2009 "Gary''s Student" wrote: Be sure to use the Import Wizard when you import the data. You can tell the Wizard what the format is. -- Gary''s Student - gsnu200836 "Kristi" wrote: When I import a date from an external source, my date month and day get flipped unless the day is greater than 12 then it reverts to text. Any suggestions on what to do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My books appears horizontally flipped, how can i fix this? | Excel Discussion (Misc queries) | |||
| Less than/ Greater than logic flipped. | Excel Discussion (Misc queries) | |||
| Less than/ Greater than logic flipped | Excel Discussion (Misc queries) | |||
| Excel Columns & Rows Flipped | Excel Discussion (Misc queries) | |||
| Will Excel import a spooled file to look the same every month? | Excel Worksheet Functions | |||
Linear Mode
