Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell shows formula not the result
Hi
I have an unusual problem. When I change the formula (in this instance a VLOOKUP when I change the range) the cell shows the formula not the result, (as if I had put a ' before the = or typed CTRL+`) - It only effects cells I change in one column in my spreadsheet - If I drag the original formula down I dont get this problem - I do not think I have changed any settings I am using Excel 2003 SP2 on Windows XP Pro SP2 Thanks in advance for any help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell shows formula not the result
The cell was formatted to Text after the formula was applied.
For example put =1+2 in a cell - cell will show 3 - formula bar shows the formula Format the cell as Text - cell STILL shows 3 - formula bar STILL shows the formula Edit for formula, make the 2 into a 5 - now the cell shows only the formula -- Gary's Student gsnu200703 "ExcelEd" wrote: Hi I have an unusual problem. When I change the formula (in this instance a VLOOKUP when I change the range) the cell shows the formula not the result, (as if I had put a ' before the = or typed CTRL+`) - It only effects cells I change in one column in my spreadsheet - If I drag the original formula down I dont get this problem - I do not think I have changed any settings I am using Excel 2003 SP2 on Windows XP Pro SP2 Thanks in advance for any help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell shows formula not the result
Thanks! - it works fine now
"Gary''s Student" wrote: The cell was formatted to Text after the formula was applied. For example put =1+2 in a cell - cell will show 3 - formula bar shows the formula Format the cell as Text - cell STILL shows 3 - formula bar STILL shows the formula Edit for formula, make the 2 into a 5 - now the cell shows only the formula -- Gary's Student gsnu200703 "ExcelEd" wrote: Hi I have an unusual problem. When I change the formula (in this instance a VLOOKUP when I change the range) the cell shows the formula not the result, (as if I had put a ' before the = or typed CTRL+`) - It only effects cells I change in one column in my spreadsheet - If I drag the original formula down I dont get this problem - I do not think I have changed any settings I am using Excel 2003 SP2 on Windows XP Pro SP2 Thanks in advance for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Cell shows formula eg ='Sheet21'!F3 instead of result | Excel Worksheet Functions | |||
Formula result not displaying in cell | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Cell shows only formula, no result | Excel Worksheet Functions |