How to fix my spreadsheet from showing formula to showing answer

S

SimplyQuick

I know it should be a simple fix but in Excel 2007, I can't find where (or
how I did it in the first place) to fix the cell in my spreadsheet to show
the actual Sum and not the formula - Help please
 
S

SimplyQuick

Thanks Thomas ---- some of these keyboard shortcuts slip away. I really
appreciate the help.

Thomas said:
SimplyQuick,

CTRL+~ should work. The ~ is located next to the 1.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


SimplyQuick said:
I know it should be a simple fix but in Excel 2007, I can't find where (or
how I did it in the first place) to fix the cell in my spreadsheet to show
the actual Sum and not the formula - Help please
 
T

Thomas [PBD]

SimplyQuick,

You're very welcome and thanks for the feedback.

--
--Thomas [PBD]
Working hard to make working easy.


SimplyQuick said:
Thanks Thomas ---- some of these keyboard shortcuts slip away. I really
appreciate the help.

Thomas said:
SimplyQuick,

CTRL+~ should work. The ~ is located next to the 1.

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


SimplyQuick said:
I know it should be a simple fix but in Excel 2007, I can't find where (or
how I did it in the first place) to fix the cell in my spreadsheet to show
the actual Sum and not the formula - Help please
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top