| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text format imported date not wanted
Hi,
I have a problem that involves date values of exported reports from a 3rd party application that autogenerates the spreadsheet, whereby, ANY date over 12 (regional date format = *14/03/2001) eg; 13/07/2007, is imported as a text string 20070713 and refuses to reformat once the import is complete. I've checked all Office option settings without result and am heading towards it being something to do with DDE in the translation? Can anyone shed some light on a solution please? -- Keep the light on... and burn bright, not out... CopperHead ;-D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format in imported lotus 123 file | New Users to Excel | |||
| Imported data changes to date format (5-1-5 changes to May 1, 2005 | Excel Discussion (Misc queries) | |||
| unable to change date format on imported data | Excel Discussion (Misc queries) | |||
| Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
| imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
Threaded Mode
