Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|