How do I change the serial date to a dd/mm/yyyy format

  • Thread starter Thread starter minkypuss
  • Start date Start date
M

minkypuss

Somehow a colleague has managed to change the way excel displays the date. It
is now showing as the serial format even though it is formatted as
dd/mm/yyyy. How do I get it to change back again?
 
go to start | control panel | date,time,regional setting | change the
format of numbers, dates & times | customize | change the format as u
want | apply | ok | ok
 
Thanks for the quick response. This is only happening on one particular
spreadsheet and is not global so changing these settings will not help ( I
did check and they are correct). Any other ideas?
 
Could be as simple as highlighting the column, go to Format - Cells - Number
- Date and select the *3/14/2001 option.
 

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

Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
reformat dates to yyyy/mm/dd 5
Forcing a date entry format of dd/mm/yyyy 1
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
yyyy-mm-dd date format? 3
Changing date to eliminate day in format mm/dd/yyyy 1
convert Julian date to DD/MM/YYYY 7
dd/mm/yyy date format 3

Back
Top