US Date Format

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
 
P

Peo Sjoblom

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

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.
 
A

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
 

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

date format 1
Preserving date format 1
Conditional formatting of date-cell - 2007 5
Date Format Not Responding to MM/DD/YY 2
Date formatting from user form to worksheet 6
Combo Box Showing Date Selections 2
Weird date format problem 2
date format 5

Top