| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format change
Hi, I have data in the CSV file and in one column there is DATE values. If i open the csv file in Excel, and the value in a cell i "01/10/2006". If i open the same .csv file through vba codin Application.workbooks.open(...) then the cell value shows as "10/01/2006". Is there any way that i can get the original value "01/10/2006" Thanks in advance mtpsures -- mtpsures ----------------------------------------------------------------------- mtpsuresh's Profile: http://www.excelforum.com/member.php...fo&userid=3181 View this thread: http://www.excelforum.com/showthread.php?threadid=55821 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
![mtpsuresh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
