displaying results and not formulas

[Marc S]

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!

 

[Frank Kabel]

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

 

[Stacey]

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