Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas displayed in cell rather than calculated values?
I have this problem come up at randon about once or twice a year. I always
have my options set to show formula values in a cell, never the formulas themselves. However, once in a while, when I type in a formula and hit enter, the formula appears in the cell and not the value. Today, I typed a new formula over an old formula that was displaying the old value. When I hit return at the end of the new formula the formula stays in the cell, not the new value. I can copy the old formula back in from a back up copy and the values will appear, but if I type the old formula in I get the formula displayed. I've checked "Excel OptionsAdvancedDisplay Options for this WorksheetShow formulas in cells instead of their calculated result" again and it is still unchecked. I tried saving the file, closing and reopening but it just comes up the same way. Very frustrating. What am I doing wrong? I'm not a novice user, but this is kicking me in the teeth! When I need to make a change, I can't. Don |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas displayed in cell rather than calculated values?
Hi,
press CTRL + ~ ~ is the key at the left of number 1 "Don M." wrote: I have this problem come up at randon about once or twice a year. I always have my options set to show formula values in a cell, never the formulas themselves. However, once in a while, when I type in a formula and hit enter, the formula appears in the cell and not the value. Today, I typed a new formula over an old formula that was displaying the old value. When I hit return at the end of the new formula the formula stays in the cell, not the new value. I can copy the old formula back in from a back up copy and the values will appear, but if I type the old formula in I get the formula displayed. I've checked "Excel OptionsAdvancedDisplay Options for this WorksheetShow formulas in cells instead of their calculated result" again and it is still unchecked. I tried saving the file, closing and reopening but it just comes up the same way. Very frustrating. What am I doing wrong? I'm not a novice user, but this is kicking me in the teeth! When I need to make a change, I can't. Don |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas displayed in cell rather than calculated values?
You're not doing anything wrong.
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. Don M. wrote: I have this problem come up at randon about once or twice a year. I always have my options set to show formula values in a cell, never the formulas themselves. However, once in a while, when I type in a formula and hit enter, the formula appears in the cell and not the value. Today, I typed a new formula over an old formula that was displaying the old value. When I hit return at the end of the new formula the formula stays in the cell, not the new value. I can copy the old formula back in from a back up copy and the values will appear, but if I type the old formula in I get the formula displayed. I've checked "Excel OptionsAdvancedDisplay Options for this WorksheetShow formulas in cells instead of their calculated result" again and it is still unchecked. I tried saving the file, closing and reopening but it just comes up the same way. Very frustrating. What am I doing wrong? I'm not a novice user, but this is kicking me in the teeth! When I need to make a change, I can't. Don -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas displayed in cell rather than calculated values?
Format cell as: General
"Don M." wrote: I have this problem come up at randon about once or twice a year. I always have my options set to show formula values in a cell, never the formulas themselves. However, once in a while, when I type in a formula and hit enter, the formula appears in the cell and not the value. Today, I typed a new formula over an old formula that was displaying the old value. When I hit return at the end of the new formula the formula stays in the cell, not the new value. I can copy the old formula back in from a back up copy and the values will appear, but if I type the old formula in I get the formula displayed. I've checked "Excel OptionsAdvancedDisplay Options for this WorksheetShow formulas in cells instead of their calculated result" again and it is still unchecked. I tried saving the file, closing and reopening but it just comes up the same way. Very frustrating. What am I doing wrong? I'm not a novice user, but this is kicking me in the teeth! When I need to make a change, I can't. Don |
#5
|
|||
|
|||
Quote:
try this: step 1: right click on the cell where you have formulae, step 2: choose general step 3: go to formulae bar and place the cursor at the end of the formulae step 4: hit the enter button all the best
__________________
Thanks Bala |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas displayed in cell rather than calculated values?
Thank you everyone! That was a new to me. Problem solved.
Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula displayed, not calculated | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
calculated value displayed in increments | Excel Discussion (Misc queries) | |||
filtered values can displayed in certain cell | Excel Worksheet Functions | |||
displayed cell values | Excel Worksheet Functions |