Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet is only showing formulas not the actual values
I cannot get the spreadsheet to show the numbers not formulas. Not sure how
it got that way, it has been working fine but other folks access the sheet it is a budgeting spreadsheet linked to others |
#2
|
|||
|
|||
Hi John
try, tools / options / view tab, untick formulas. Cheers JulieD "John" wrote in message ... I cannot get the spreadsheet to show the numbers not formulas. Not sure how it got that way, it has been working fine but other folks access the sheet it is a budgeting spreadsheet linked to others |
#3
|
|||
|
|||
John
Either you have View Formulas checked in ToolsOptionsView or the cells are pre-formatted as text. Hit CRTL + `(above TAB key) to toggle Formula View on/off, if that is the case. If text cells, select the cells and Format as General then re-enter by selecting a cell and hitting F2 then <ENTER. For a bunch of formulas a quick way to re-enter them is to select the cells then EditReplace what: = with: = Replace all. Gord Dibben Excel MVP On Wed, 24 Nov 2004 07:49:05 -0800, "John" wrote: I cannot get the spreadsheet to show the numbers not formulas. Not sure how it got that way, it has been working fine but other folks access the sheet it is a budgeting spreadsheet linked to others |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill formulas and values | Excel Discussion (Misc queries) | |||
linked values in a chart | Charts and Charting in Excel | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) | |||
Why do formulas turn to values wen copying in Excel 2003... | Excel Worksheet Functions |