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

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?

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

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


On Sep 22, 12:41*pm, minkypuss
wrote:
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?

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

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?

"muddan madhu" wrote:

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


On Sep 22, 12:41 pm, minkypuss
wrote:
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?

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

I think he might used this one

=TEXT(A1,"ddmmyyyy")

On Sep 22, 1:15*pm, minkypuss
wrote:
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?



"muddan madhu" wrote:
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

On Sep 22, 12:41 pm, minkypuss
wrote:
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?- Hide quoted text -

- Show quoted text -

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

Could be as simple as highlighting the column, go to Format - Cells - Number
- Date and select the *3/14/2001 option.

"muddan madhu" wrote:

I think he might used this one

=TEXT(A1,"ddmmyyyy")

On Sep 22, 1:15 pm, minkypuss
wrote:
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?



"muddan madhu" wrote:
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

On Sep 22, 12:41 pm, minkypuss
wrote:
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?- Hide quoted text -

- Show quoted text -