| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted date conversion when opening a workbook
I have a document, saved as text from another application (business objects) which contains the value 01/06/2004 (1st June 2004) in cell A5
When I open the workbook mannually I see the correct date, but when I open it with code (workbooks.open("path.xls")) it comes up with 01/06/200 Any help Thank Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 General Formating Unwanted Text to Date Conversion | Excel Discussion (Misc queries) | |||
| Opening at Unwanted | Excel Discussion (Misc queries) | |||
| Unwanted data conversion in cells | Excel Discussion (Misc queries) | |||
| unwanted csv date conversion | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Threaded Mode
