| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with date format when reading external excel sheet
Hi There
You could try using cdate rather than formatting the date i.e. ..cells(ml_TARGET_ROW, 10).Value = CDate (rs_SOURCE("Period end")) 'where the data in the parenthesis is your date Hope this helps Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not reading date format | Excel Discussion (Misc queries) | |||
| Copnvert dates reading as Text to a date format | Excel Discussion (Misc queries) | |||
| Reading from CSV date format | Excel Programming | |||
| Date format problems ... | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
