US Date Format

[Will]

It drives me insane that it appears not to be possible to
enter a date in an Excel spreadsheet except in a US
format ie mm/dd/yy. Is there an option to customise this
or your programme for us in the UK where all dates are
referred to in dd/mm/yy format

 

[Peo Sjoblom]

That setting is in the control panel regional setting (options)
I have no problems changing that to dd/mm/yy

 

[Norman Harker]

Hi Will!

Use:

Start > Control Panel > Regional Settings

You need to change your date settings to dd/mm/yy

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Andy B]

Will

This option is set in Regional Settings in your control panel.

Andy.

 

[Andrew]

You can also change form the mm/dd/yy format to a dd/mm/yy format b
right-clicking the cell(s) and selecting the Format Cells option.

At the bottom of the Number tag, you should see Custom. Ente
dd/mm/yy, then press OK