Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My regional settings are currently for UK, which displays dates as dd/mm/yyyy.
If I create a new workbook, and write this simple code: Range("A1")="01/09/2014" it appears in cell A1 as 09/01/2014. Why would it assume I was giving it the date in US format, and how can tell it not to? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel changing date format after VB has run | Excel Worksheet Functions | |||
Date format diplays incorrectly | Excel Worksheet Functions | |||
Excel 2003 - Changing Date Format | Excel Discussion (Misc queries) | |||
Excel 2002 - Date format keeps changing | Excel Discussion (Misc queries) | |||
excel is changing date format | Setting up and Configuration of Excel |