Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returns cell name
Tools--Options--View--make sure 'view formulas' is not selected.
Also make sure there isn't an apostrophe in front of the formula. Finally, make sure the cell in question is not formatted as text. "rjvega" wrote: I'm messing around with a worksheet of mine doing random formatting things. After doing a conditional format (which I have since removed), every time I enter a simple formula in the affected cells I get the cell name instead of the value. Example: Cell A2 contains the value 3.75. In cell E2, I enter =A2 and instead of 3.75, E2 shows =A2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |