Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Tools|options|view tab|uncheck formulas (the menu equivalent of the
ctrl-backquote shortcut) But your cells could be formatted as text, so excel sees the strings as plain old text--not a formula to evaluate. Try formatting a cell as General (or anything but Text) and with that cell still selected, hit F2, then enter. If that works, then try formatting all the offending cells as General, then with that range selected: edit|Replace what: = (equal sign) with: = replace all jalbert1975 wrote: All of a sudden, all of my formulas are appearing instead of their output. I have tried Ctrl+`, and Tools-Formula Auditing-Formula Auditing Mode. I can't get rid of them. This just started yesterday, and I have no idea why. What can I do? -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) |