Forum Discussion
Excel Date Format
I have a vba script that pulls various fields out of a number of excel sheets into a single table. One of those fields is a date which is formatted as Date > *14/04/2012 and Locale= English(United K...
I have a Date validation trap on the field so strange that it is seeing it as text.
The ones that stay as text are doing so in the target sheet - but remain 'UK'. The ones that do covert to numbers if formatted are swapping to American format 😞
The ones that stay as text are doing so in the target sheet - but remain 'UK'. The ones that do covert to numbers if formatted are swapping to American format 😞
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?