US Date Format

  • Thread starter Thread starter Will
  • Start date Start date
W

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
 
That setting is in the control panel regional setting (options)
I have no problems changing that to dd/mm/yy
 
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.
 
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
 
Back
Top