Excel 2003: Error with date formatting

B

bird007

Hi,

Everytime I enter dates into my spreadsheet it converts is into US format.
I have checked my Regional & Language Options on the Control Panel - the
location says Australia (correct) and I have also formatted the 'date' cells
as English (Australian).
Can anyone help me on this annoying problem.

Thanks,
Kerryn
 

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
Default Date Format in Excel 3
Default date format (with shortcut keys) 2
Remove date format? 3
Excel Date Formatting 0
Forcing a date entry format of dd/mm/yyyy 1
Excel not using regional settings 6
Excel 2007 displayed dates 2

Top