Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to have only the values show in a spreadsheet.
I am helping a user add "----" to a blank cell. They want it so that it
centers under the number above it. The spreadsheet keeps showing the formula "=d47=c34". I want to save it as a new document and have only the values appear (not sure how it was created). Please advise. Thank you. |
#2
|
|||
|
|||
Debutante
First of all, what has that formula to do with adding "----" to a blank cell? Second of all, if your formula(s) are showing and not values, could be that you have Formula View enabled. Hit CTRL + `(backquote above TAB key) to toggle formula view on/off. If not in formula view, perhaps the cell is formatted as text. Re-format as General and hit F2 and <ENTER. To change all formulas to values, select the cells and Copy then(in place) Paste SpecialValuesOKEsc. Gord Dibben Excel MVP On Fri, 21 Jan 2005 10:09:07 -0500, "Debutante" wrote: I am helping a user add "----" to a blank cell. They want it so that it centers under the number above it. The spreadsheet keeps showing the formula "=d47=c34". I want to save it as a new document and have only the values appear (not sure how it was created). Please advise. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
linked values in a chart | Charts and Charting in Excel | |||
Formula to list unique values | Excel Worksheet Functions | |||
only show updated values | New Users to Excel | |||
Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions |