Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have the new excel program and I can't figure out how to get the results of
a formula to show in the cell instead of the formula itself. The old program displayed the results! That is what I want, how do I do that? ie....=SUMPRODUCT(+D3+D4+D5+D7+D8) should be xyz dollars, not .....=SUMPRODUCT(+D3+D4+D5+D7+D8). ARRRGGHHHHH |
#2
![]() |
|||
|
|||
![]()
I have had sinmilar issues - but forst make sure that in
Tools - Options - View Tab - you havent got the "Formulas" check box ticked somehow. However if this is not the case, then on occaision I have had this - I got around it by copying a cell which showed the vlaue OK, then paste special the format over the offending cell. I never figured out what caused this to happen - theres probably a good one that someone can explain - and we can then both deal with this issue more wholistically... ttfn benm |
#3
![]() |
|||
|
|||
![]()
I have had sinmilar issues - but forst make sure that in
Tools - Options - View Tab - you havent got the "Formulas" check box ticked somehow. However if this is not the case, then on occaision I have had this - I got around it by copying a cell which showed the vlaue OK, then paste special the format over the offending cell. I never figured out what caused this to happen - theres probably a good one that someone can explain - and we can then both deal with this issue more wholistically... ttfn benm |
#4
![]() |
|||
|
|||
![]()
Hi
some ideas: 1. check the format of these cells. If they're set to 'Text' change them to<'General' and re-enter your formual 2. Goto 'Tools - Options - View' and make sure 'Formulas' is unchecked -- Regards Frank Kabel Frankfurt, Germany ocbecky wrote: I have the new excel program and I can't figure out how to get the results of a formula to show in the cell instead of the formula itself. The old program displayed the results! That is what I want, how do I do that? ie....=SUMPRODUCT(+D3+D4+D5+D7+D8) should be xyz dollars, not ....=SUMPRODUCT(+D3+D4+D5+D7+D8). ARRRGGHHHHH |
#5
![]() |
|||
|
|||
![]()
Try ctrl-~. This toggles between displaying the formula itself and the result.
"Frank Kabel" wrote: Hi some ideas: 1. check the format of these cells. If they're set to 'Text' change them to<'General' and re-enter your formual 2. Goto 'Tools - Options - View' and make sure 'Formulas' is unchecked -- Regards Frank Kabel Frankfurt, Germany ocbecky wrote: I have the new excel program and I can't figure out how to get the results of a formula to show in the cell instead of the formula itself. The old program displayed the results! That is what I want, how do I do that? ie....=SUMPRODUCT(+D3+D4+D5+D7+D8) should be xyz dollars, not ....=SUMPRODUCT(+D3+D4+D5+D7+D8). ARRRGGHHHHH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell reference in a formula is called | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
How do identify a blank cell in a formula | Excel Discussion (Misc queries) | |||
Is there a way to transfer a style by cell referrence in a formula | Excel Discussion (Misc queries) |