Excel: Cells Don't Show Expected Number Formatting

 Last reviewed: October 31, 1994
Article ID: Q48199

SUMMARY

In Microsoft Excel, numbers do not display with formatting when formulas are displayed.

Macro sheets default to displaying formulas instead of values. To display formatted numbers on a worksheet or macro sheet, do the following:

  1. From the Options menu, choose Display.

  2. Deselect Formulas by removing the "X" from the Formulas check box.

  3. Click OK.

MORE INFORMATION

Excel versions 3.00 and 2.20 also incorporate a shortcut key command to switch between formula and value displays. Press COMMAND+` (back apostrophe) to toggle between the two displays.

Note: If you are using On Cue, QuickKeys, Tempo, or some other program that configures the keyboard, this keyboard option may be available due to the use of this keystroke by these programs. To use this keystroke, reconfigure the program to not use this key command.

KBCategory: kbother
KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.