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

Excel does not accept text format! 0
Fixing the date format in a macro or VBA 1
DATE FORMAT NOT WORKING 6
Doughnut Chart linked with the slicer in the pivot table 0
How do i combine 2 cells contain date in one cell, 2
#NAME? error for no apparent reason... 4
Converting european date format to US format. 3
Sorting Dates in format "01/19/09" 4

Top