Why does Custom Format not control Cell Display?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

XL 2003

Have a cell which shows in the formula bar:
06/10/2005 10:10:32 AM

In the worksheet (same cell but unselected) the display is:
38513.4239814815

No matter what I do with cell formating i.e. general to
text to custom (BTW which is mm/dd/yyyy h:mm) the cell
displays 38513.4239814815 UNLESS I select the cell - then
it displays 06/10/2005 10:10:32 AM?

When I de-select the cell it reverts back to 38513.4239814815

I thought that I knew better! What is the very obvious thing that I am
missing?

Dennis
 
Maybe you're looking at formulas...

Tools|options|view tab
Uncheck Formulas

There's a shortcut key that toggles this setting
ctrl-`
ctrl-backquote. The backquote is to the left of the 1/! key on my USA
keyboard.)

Maybe you hit that combination in error.
 

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

Excel 2007 displayed dates 2
Default date format (with shortcut keys) 2
Excel Formula Bar Time Display Format 2
Cell display is 38727.4101273148 Formula Bar is 1/10/2006 9:50 3
MM/YY Formatting date Entry AND Display 2
Excel 2002: How to make the date format uniform ? 1
cell format - not automatically taking effect 4
Formatting a date/time cell 1

Back
Top