Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excell, how do I change the date from 39443 to 12/27/08?
One page in Excell 2005 suddenly started putting all the dates just numbers,
such as 39443. I can copy a cell with a number and paste it into another cell in another page and it will display the correct date. I've tried formatting the cells but nothing I've tried will work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excell, how do I change the date from 39443 to 12/27/08?
Try this. press Ctrl+Accent grave, the key above the tab key and to the left
of the 1 key. Tyro "Darrell Johnson" <Darrell wrote in message ... One page in Excell 2005 suddenly started putting all the dates just numbers, such as 39443. I can copy a cell with a number and paste it into another cell in another page and it will display the correct date. I've tried formatting the cells but nothing I've tried will work. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excell, how do I change the date from 39443 to 12/27/08?
Perhaps you are in "View Formula" mode in that sheet(not "page")
Hit CTRL + ` to toggle out of that mode. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 15:53:01 -0700, Darrell Johnson <Darrell wrote: One page in Excell 2005 suddenly started putting all the dates just numbers, such as 39443. I can copy a cell with a number and paste it into another cell in another page and it will display the correct date. I've tried formatting the cells but nothing I've tried will work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do column widths change in Excell? | Excel Worksheet Functions | |||
How do I change the date format in Excell from eg 20060926 | Excel Discussion (Misc queries) | |||
How do I change excell doc to all caps? | Excel Discussion (Misc queries) | |||
the scroll wheel goes across in excell how do i change this | Excel Discussion (Misc queries) | |||
I cannot get excell to change to landscape | Excel Discussion (Misc queries) |