| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates exported as text
I am running Sage in the UK and when I export a report the dates are exported as text. I then need to change the format to "dd/mm/yy" - select the cell and then press enter. I have written some VBA code to automate this - but it does not work on dates such as 25th March 2005 - because Excel thinks that 25 is the month and 3 is the day. Has anyone experienced a similar problem - Is there a solution? Many Thanks, Michael -- michael.a7 ------------------------------------------------------------------------ michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027 View this thread: http://www.excelforum.com/showthread...hreadid=528494 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns formatted As Dates Are Exported as a Number to Text | Excel Discussion (Misc queries) | |||
| Data from exported file read as text, when edited becomes a # (pic | Excel Discussion (Misc queries) | |||
| Exported from Access - text has a character before it | Excel Discussion (Misc queries) | |||
| Need quotes around exported tab delimited text | Excel Discussion (Misc queries) | |||
| why are there quotes in my exported text file? | Excel Discussion (Misc queries) | |||
![michael.a7[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
