In Excell, how do I change the date from 39443 to 12/27/08?

D

Darrell Johnson

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.
 
T

Tyro

Try this. press Ctrl+Accent grave, the key above the tab key and to the left
of the 1 key.

Tyro
 
G

Gord Dibben

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
 

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

How to change a date from 19990812 to 08-12-1999? 3
Adding days to a date - changed in Excel 2010 8
How can I subtract one date and time from another in Excell? 8
how do i use averageifs function? 2
getting the next date based on another date 6
How do I import data from 1 excell workbook to another? 1
Some date &/or Times will not format 1
Formatting cells to show two dates in one cell 3

Top