| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Saves In Cell But Does Not Compute
For some reason in parts of my spreadsheet when I type a formula in a cell
and save it, the formula text will save and show in the cell, but the actual formula calculations will not work. Help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Saves In Cell But Does Not Compute
Check that the format is not text
-- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "roy.okinawa" wrote in message ... For some reason in parts of my spreadsheet when I type a formula in a cell and save it, the formula text will save and show in the cell, but the actual formula calculations will not work. Help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Saves In Cell But Does Not Compute
Hi!
Those cells have been formatted as TEXT. One way to fix: Select the cells in question Goto EditReplace Find what: = Replace with: = Replace All Biff "roy.okinawa" wrote in message ... For some reason in parts of my spreadsheet when I type a formula in a cell and save it, the formula text will save and show in the cell, but the actual formula calculations will not work. Help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Saves In Cell But Does Not Compute
That was it.
Thanks. "Peo Sjoblom" wrote: Check that the format is not text -- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "roy.okinawa" wrote in message ... For some reason in parts of my spreadsheet when I type a formula in a cell and save it, the formula text will save and show in the cell, but the actual formula calculations will not work. Help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| looking for a formula | Excel Worksheet Functions | |||
Linear Mode
