| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format Changes on Copy
Has anyone come across this one...?
Whilst copying from a .csv file into an existing Excel workbook a strange things happens... The first column of my range loses its date format and changes from a UK (the one I want) to a US format, peculiarly only on some cells! Setting the format on the destination cells first first makes no difference. I'm doing the copy in VBA using: wkbSource.Sheets(1).UsedRange.Copy _ wkbTarget.Sheets("Timesheet Actuals").Range("A2") Even more peculiarly, if I carry out the copy by hand the problem doesn't occur...! TIA Jon C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| Changing date format in copy paste | Excel Discussion (Misc queries) | |||
| Copy/Paste Special (Date Format) | Excel Discussion (Misc queries) | |||
| How do I maintain my date format, when I copy a sheet, in excel? | Excel Discussion (Misc queries) | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
![Jon C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
