| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am getting formula displayed in some cells rather than the resul
For random individual cells within one worksheet. I can't find where you
tell at the individual cell level to display formula or result. V. annoying. Thanks in advance. -- GG |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am getting formula displayed in some cells rather than the resul
Try this,
Sounds like they may be formatted as TEXT Select the offending cell and format as general. Tap F2 Tap enter Mike "GG" wrote: For random individual cells within one worksheet. I can't find where you tell at the individual cell level to display formula or result. V. annoying. Thanks in advance. -- GG |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am getting formula displayed in some cells rather than the resul
Those cells were formatted as text before you entered the formula.
Just reformatting is not enough; format as General or Number AND re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "GG" wrote in message ... | For random individual cells within one worksheet. I can't find where you | tell at the individual cell level to display formula or result. | | V. annoying. | | Thanks in advance. | -- | GG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| Fill down function not working correctly and producing weird resul | Excel Worksheet Functions | |||
| Formulas displayed in all of my cells | Excel Worksheet Functions | |||
| Formula, not the result is displayed in calculated cells - why? | Excel Worksheet Functions | |||
| Whether 3 diff fields are blank determines several different resul | Excel Worksheet Functions | |||
Linear Mode
