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

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?
 
M

muddan madhu

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
 
M

minkypuss

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?
 
S

Sean Timmons

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

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
reformat dates to yyyy/mm/dd 5
Returning the month (mmm) from cell in date format dd/mm/yyyy 3
Date Formats 4

Top