displaying results and not formulas
 

I have a worksheet that is currently displaying formulas in some cells and
results in others. I have tried everything that I know to get all cells to
display only results but nothing is working. Anyone have any ideas??

Thank you!

Hi
check if the cells are not formated as 'Text' (Format - Cells'). Change
the format to 'General' and re-enter the formula

--
Regards
Frank Kabel
Frankfurt, Germany

"Marc S" <Marc schrieb im Newsbeitrag
...
I have a worksheet that is currently displaying formulas in some
cells and
results in others. I have tried everything that I know to get all
cells to
display only results but nothing is working. Anyone have any ideas??

Thank you!

Thank you thank you thank you. I too was having that problem and you have
saved me hours of cutting and pasting.

"Frank Kabel" wrote:

Hi
check if the cells are not formated as 'Text' (Format - Cells'). Change
the format to 'General' and re-enter the formula

--
Regards
Frank Kabel
Frankfurt, Germany

"Marc S" <Marc schrieb im Newsbeitrag
...
I have a worksheet that is currently displaying formulas in some
cells and
results in others. I have tried everything that I know to get all
cells to
display only results but nothing is working. Anyone have any ideas??

Thank you!