How do I format cells to show date in Australian not US format?

K

Kevin B

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?
 
F

Fred Smith

Excel uses the date format you have specified in your Windows Regional
Settings. Go to Control Panel, and change your regional settings.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixing the date format in a macro or VBA 1
DATE FORMAT NOT WORKING 5
How do i combine 2 cells contain date in one cell, 2
Workday Formula to include date 0
#NAME? error for no apparent reason... 2
& in formula changing date format to text ? 5
Sorting Dates in format "01/19/09" 8
How to conditional format columns in a range based on 5

Top