Formatting cells in Excel

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

Guest

Help! My ability to format a cell in Excell has suddenly disappeared! Any
date I input will only show the serial number format and I cannot get it to
change. What can I do?
 
Sounds like you are in "View Formula" mode.

Hit CTRL + `(above Tab key) to toggle off/on.


Gord Dibben MS Excel MVP
 
Gord --

That was it! Thanks for the help!!!



Gord Dibben said:
Sounds like you are in "View Formula" mode.

Hit CTRL + `(above Tab key) to toggle off/on.


Gord Dibben MS Excel MVP
Click to expand...
 
You must log in or register to reply here.

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 Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CONDITIONAL FORMATTING QUERY 0
Date formatting 4
Data exported to excel 2007 changes cell number format to 'general' ? 1
number format in excel 3
Editing conditional formats (Excel 2010) 15
Formatting Cells - Hex Values 3
Excel cannot find or read file 5

Back
Top