Cell shows formula eg ='Sheet21'!F3 instead of result
I have a problem where when I insert a formula such as ='Sheet21'!F3, the
cell shows the formula, instead of the result. This isn't consistent apparently. I have managed to copy the formula from another cell that works, but when I then change the cell ref (e.g F3 to F4 in the above example), the cell displays the formula again, instead of the result. Cell format is "Text". Is this a cell formatting issue?? |
Cell shows formula eg ='Sheet21'!F3 instead of result
<Is this a cell formatting issue??
Yes. Format as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "mikehutt" wrote in message ... |I have a problem where when I insert a formula such as ='Sheet21'!F3, the | cell shows the formula, instead of the result. This isn't consistent | apparently. I have managed to copy the formula from another cell that works, | but when I then change the cell ref (e.g F3 to F4 in the above example), the | cell displays the formula again, instead of the result. Cell format is | "Text". Is this a cell formatting issue?? |
All times are GMT +1. The time now is 01:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com