| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| m/yy or m/yyyy date format | Excel Discussion (Misc queries) | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| change yyyy date to yy | Excel Discussion (Misc queries) | |||
Linear Mode
