Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEVALUE, etc. and Australian date format
I have a client in Australia that uses dd/mm/yyyy as their default date
format. Applications that use DATEVALUE or similar functions that take a date string used to work on "24/03/2008" but now they do not. Am I missing something, or is this an error/enhancement in Excel 2007? Is there a solution? -- Lolt Proegler |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEVALUE, etc. and Australian date format
On Tue, 25 Mar 2008 18:11:00 -0700, LProegler <MrLolt wrote:
I have a client in Australia that uses dd/mm/yyyy as their default date format. Applications that use DATEVALUE or similar functions that take a date string used to work on "24/03/2008" but now they do not. Am I missing something, or is this an error/enhancement in Excel 2007? Is there a solution? Check the date format when you select Start/Control Panel/Regional and Language settings. DATEVALUE should work OK on dates that conform to the format in Control Panel/Regional and Language settings. The date format within Excel itself does not affect this. When my Regional and Language settings are English(US), =DATEVALUE("24/03/2008") -- #VALUE! But if I change it to English(Australian), the same formula -- 39531 which is 28/03/2008 when formatted as a date. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change date format from US to English (Australian) | Excel Discussion (Misc queries) | |||
australian date format | Excel Discussion (Misc queries) | |||
Australian date format in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) |