Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula stays in the cell
The formula result does not display in the cell, instead the formula itself
displays in the cell. I have tried different formats but continue to have the same problems. |
#2
|
|||
|
|||
Hi Mindie
two possible problems first check tools / options / view and ensure that formulas is not ticked second it is possible that the cell has been formatted to text - select a cell from a new sheet and choose copy, now select your formulas and choose edit / paste special - Add ... you then might need to choose edit / replace and type a = in both the find and replace lines and do a replace all. hope this helps Cheers JulieD "Mindie" wrote in message ... The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#3
|
|||
|
|||
Sounds like Excel is set to display formulas.
Press Ctrl+` That's the button directly below the Esc Key on most keyboards. tj "Mindie" wrote: The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#4
|
|||
|
|||
Look at:
<Tools <Options <View tab, And make sure that "Formulas" is *UNchecked*. If it already is unchecked, try this: Select the cell with the "bad " formula, then: <Ctrl <Shift <~ Then, <F2 Then <Enter What you did here was format the cell to "General", then re-entered it. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mindie" wrote in message ... The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#5
|
|||
|
|||
Thanks, that did the trick!
"RagDyeR" wrote: Look at: <Tools <Options <View tab, And make sure that "Formulas" is *UNchecked*. If it already is unchecked, try this: Select the cell with the "bad " formula, then: <Ctrl <Shift <~ Then, <F2 Then <Enter What you did here was format the cell to "General", then re-entered it. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mindie" wrote in message ... The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#6
|
|||
|
|||
Thanks for the feed-back ... BUT ... out of curiosity,
Which one "did the trick" ? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mindie" wrote in message ... Thanks, that did the trick! "RagDyeR" wrote: Look at: <Tools <Options <View tab, And make sure that "Formulas" is *UNchecked*. If it already is unchecked, try this: Select the cell with the "bad " formula, then: <Ctrl <Shift <~ Then, <F2 Then <Enter What you did here was format the cell to "General", then re-entered it. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mindie" wrote in message ... The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#7
|
|||
|
|||
I was having the same problem, and your tip (format to general and edit)
solved it. Why would Excel work that way? Seems like a bug. "Ragdyer" wrote: Thanks for the feed-back ... BUT ... out of curiosity, Which one "did the trick" ? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mindie" wrote in message ... Thanks, that did the trick! "RagDyeR" wrote: Look at: <Tools <Options <View tab, And make sure that "Formulas" is *UNchecked*. If it already is unchecked, try this: Select the cell with the "bad " formula, then: <Ctrl <Shift <~ Then, <F2 Then <Enter What you did here was format the cell to "General", then re-entered it. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mindie" wrote in message ... The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#8
|
|||
|
|||
Why would XL work which way?
Change format to Text ... Or ... Have text that *looks* like formulas, not be allowed to work as formulas? All default formatting on new WSs is "General". SO ... how did the formatting change to Text? That can only be answered by you, the user! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- keigwin" wrote in message ... I was having the same problem, and your tip (format to general and edit) solved it. Why would Excel work that way? Seems like a bug. "Ragdyer" wrote: Thanks for the feed-back ... BUT ... out of curiosity, Which one "did the trick" ? -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Mindie" wrote in message ... Thanks, that did the trick! "RagDyeR" wrote: Look at: <Tools <Options <View tab, And make sure that "Formulas" is *UNchecked*. If it already is unchecked, try this: Select the cell with the "bad " formula, then: <Ctrl <Shift <~ Then, <F2 Then <Enter What you did here was format the cell to "General", then re-entered it. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Mindie" wrote in message ... The formula result does not display in the cell, instead the formula itself displays in the cell. I have tried different formats but continue to have the same problems. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula stays in the cell
I am also having the same issue with the formulas. The two processes of
changing the format to general--F2--Enter and the find/replace "=" works well to fix the problem. However, once I try and edit the formula, it reverts back to displaying the formula itself rather than the result. Any suggestions on how to prevent this from happening? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula stays in the cell
Saved from a previous post.
Excel likes to help. Try this on a test worksheet. Select A1 and hit ctrl-; (to put the date in the cell) now select B1 and type: =a1 Notice that excel changed the format of B1 to match the format in A1. Now format D1 as Text. put ASDF in D1 put =D1 in E1 You see ASDF. With E1 selected, hit the F2 key and then enter (to pretend that you're changing the formula). Excel has "helped" you by changing that cell's format to text. I don't know of any way of changing this behavior. I just select the cell, and reformat it to General (or whatever I wanted). I hit F2 and then enter (to reenter that formula). Sometimes this feature is nice, sometimes it ain't. Mr. H wrote: I am also having the same issue with the formulas. The two processes of changing the format to general--F2--Enter and the find/replace "=" works well to fix the problem. However, once I try and edit the formula, it reverts back to displaying the formula itself rather than the result. Any suggestions on how to prevent this from happening? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
looking for a formula | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |