| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2007 formula results not displaying
I am new to Excel 2007 but have used 2003. I entered a formula in my 2007
spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
Press CTRL and ` keys together - once only
You will find ` key on top-left corner of your keyboard with ~ "Txlonghorn76" wrote: I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
My guess would be that it's the same as would happen in Excel 2003, and that
you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
i pressed the ctrl + ~ key but that did not show me the results of the
formula. "Sheeloo" wrote: Press CTRL and ` keys together - once only You will find ` key on top-left corner of your keyboard with ~ "Txlonghorn76" wrote: I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
that still didn't work. I am using the formula =RIGHT(D2,4) and that is what
is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
You didn't happen to leave the CTRL` setting as it was after trying once?
Did you re-enter the formula, as David suggested? -- Kind regards, Niek Otten Microsoft MVP - Excel "Txlonghorn76" wrote in message ... that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
Try this
Enter 1 in C1 2 in C2 Select C3 and press the autosum button... (Sigma Symbol) and let us know if you see the result or the formula.. I hope you pressed CTRL and ` keys together... and not with SHIFT key also.. "Txlonghorn76" wrote: that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
i am getting =SUM(C2:C3)
at what point am i supposed to use crtl + ~ before or after the formula? "Sheeloo" wrote: Try this Enter 1 in C1 2 in C2 Select C3 and press the autosum button... (Sigma Symbol) and let us know if you see the result or the formula.. I hope you pressed CTRL and ` keys together... and not with SHIFT key also.. "Txlonghorn76" wrote: that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
I don't have Excel 2007, but if *for every cell* you are seeing the formula
rather than the result, try the Microsoft Office button and choose Excel Options Formulas and the "Show Formulas" option should toggle between displaying the formula and the result. -- David Biddulph "Txlonghorn76" wrote in message ... that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
If you are seeing formulas then pressing CTRL-` once will show you the
results...pressing it again will show the formulas again... it is kind of a toggle... "Txlonghorn76" wrote: i am getting =SUM(C2:C3) at what point am i supposed to use crtl + ~ before or after the formula? "Sheeloo" wrote: Try this Enter 1 in C1 2 in C2 Select C3 and press the autosum button... (Sigma Symbol) and let us know if you see the result or the formula.. I hope you pressed CTRL and ` keys together... and not with SHIFT key also.. "Txlonghorn76" wrote: that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
David...
I have Excel 2007 and checked - I did not find the option you mentioned. However CTRL-` toggles between formulas and its results... "David Biddulph" wrote: I don't have Excel 2007, but if *for every cell* you are seeing the formula rather than the result, try the Microsoft Office button and choose Excel Options Formulas and the "Show Formulas" option should toggle between displaying the formula and the result. -- David Biddulph "Txlonghorn76" wrote in message ... that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel 2007 formula results not displaying
That didn't work either. Do you think some type of lock to the worksheet
would create this kind of issue? "David Biddulph" wrote: I don't have Excel 2007, but if *for every cell* you are seeing the formula rather than the result, try the Microsoft Office button and choose Excel Options Formulas and the "Show Formulas" option should toggle between displaying the formula and the result. -- David Biddulph "Txlonghorn76" wrote in message ... that still didn't work. I am using the formula =RIGHT(D2,4) and that is what is showing in the cell, not the right 4 characters. There has to be some default that the sheet is set to but I can't figure it out. "David Biddulph" wrote: My guess would be that it's the same as would happen in Excel 2003, and that you've got the cell formated as text. Format as General and re-enter the formula. -- David Biddulph "Txlonghorn76" wrote in message ... I am new to Excel 2007 but have used 2003. I entered a formula in my 2007 spreadhseet and i only see the formula in the cell, not the results. What do i need to do to have the resulst of the formula show not the formula? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Displaying-Excel 2007 | Excel Discussion (Misc queries) | |||
| IF formula results not displaying | Excel Worksheet Functions | |||
| not displaying pie chart in excel 2007 | Charts and Charting in Excel | |||
| Displaying Formula Results in Cell | Excel Discussion (Misc queries) | |||
| Displaying formula rather than results... | Excel Discussion (Misc queries) | |||
Linear Mode
