Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Format Error
Hi,
I'm importing a sheet from a .csv file into an excel workbook using the command: Sheets(1).Move The .csv sheet has a column of dates in the format dd/mm/yyyy. When I manually move the sheet (ie. tile the windows and drag-and-drop), there are no problems. But when I run the sub with the above command, some of the dates come out in dd/mm/yyyy format and others in dd/mm/yy. This messes up subsequent formulae as excel can't identify if the "yy" date are 20yy or 19yy. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format error in cell | Excel Worksheet Functions | |||
Date format error | Excel Discussion (Misc queries) | |||
Date-error Format | Setting up and Configuration of Excel | |||
Date format error in Excel | Excel Worksheet Functions | |||
Concatenate error and Date Format Error | Excel Programming |