| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported data changes to date format (5-1-5 changes to May 1, 2005
I am importing data from another program into Excel. One of the fields being
imported is in the format #-#-# and when it gets to Excel it formats it as Month day year (Ex. 5-1-5 is imported as May 1, 2005). How can I get it to import into Excel as 5-1-5? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to change date format on imported data | Excel Discussion (Misc queries) | |||
| Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Threaded Mode
