Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fix my spreadsheet from showing formula to showing answer
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fix my spreadsheet from showing formula to showing answer
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" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fix my spreadsheet from showing formula to showing answer
Copy
Edit/ Paste Special/ Values -- David Biddulph "SimplyQuick" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fix my spreadsheet from showing formula to showing answ
Thanks Thomas ---- some of these keyboard shortcuts slip away. I really
appreciate the help. "Thomas [PBD]" wrote: 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" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to fix my spreadsheet from showing formula to showing answ
SimplyQuick,
You're very welcome and thanks for the feedback. -- --Thomas [PBD] Working hard to make working easy. "SimplyQuick" wrote: Thanks Thomas ---- some of these keyboard shortcuts slip away. I really appreciate the help. "Thomas [PBD]" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a spreadsheet column showing time in 30 sec. intervals | Excel Discussion (Misc queries) | |||
Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
Showing data as spreadsheet and a line graph. | New Users to Excel | |||
Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Why is calculate showing in status bar at bottom of spreadsheet? | Excel Discussion (Misc queries) |