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

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

Top