| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format cells to show date in Australian not US format?
I have the language set on Eglish (Australian) but trying to format cells to
show date as 08-May -2008 for example. NormallyI would type 08/5/08 and it would formated as above. But now if I type that in it thinks I have typed month in first - like US mehtod. How can I change? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I format cells to show date in Australian not US format?
Excel uses the date format you have specified in your Windows Regional
Settings. Go to Control Panel, and change your regional settings. Regards, Fred. "Kevin B" wrote in message ... I have the language set on Eglish (Australian) but trying to format cells to show date as 08-May -2008 for example. NormallyI would type 08/5/08 and it would formated as above. But now if I type that in it thinks I have typed month in first - like US mehtod. How can I change? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATEVALUE, etc. and Australian date format | Excel Worksheet Functions | |||
| 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) | |||
![Kevin B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
