| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UK to US date format
I have a macro that reads;
- data from a form, and writes it to a central data sheet - and another macro that can retrieve the data and present it on the form again. In both macros the date is set as "dd-mmm-yy" format. However I am having a problem when there is a date such as 05-Jul-04. The 05 and the 07 of the day and month keep getting transposed so the date turns into 07-May-04 (!!!). Other dates (I guess ones where the day value is bigger than 12), seem fine. The network and applications at my work are set to UK date format, so why are these values changing over to US format? --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| change date format dd/mm/yyyy to Julian date format? | Excel Worksheet Functions | |||
| convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Threaded Mode
