Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New formula: = does not disappear
In an excel sheet, I am typing in a new formula: "=Master!C271". However,
instead of showing what is in that cell, it shows the formula. Does anyone know how to fix this? Thanks! |
#2
|
|||
|
|||
Hi Mike
tools / options / view - untick formulas or the cell was preformatted as text, use edit / replace - look for: = replace with: = this tends to fix it Cheers JulieD "Mike" wrote in message ... In an excel sheet, I am typing in a new formula: "=Master!C271". However, instead of showing what is in that cell, it shows the formula. Does anyone know how to fix this? Thanks! |
#3
|
|||
|
|||
Thanks Julie. This worked like a charm!
"JulieD" wrote: Hi Mike tools / options / view - untick formulas or the cell was preformatted as text, use edit / replace - look for: = replace with: = this tends to fix it Cheers JulieD "Mike" wrote in message ... In an excel sheet, I am typing in a new formula: "=Master!C271". However, instead of showing what is in that cell, it shows the formula. Does anyone know how to fix this? Thanks! |
#4
|
|||
|
|||
you're welcome and thanks for the feedback
"Mike" wrote in message ... Thanks Julie. This worked like a charm! "JulieD" wrote: Hi Mike tools / options / view - untick formulas or the cell was preformatted as text, use edit / replace - look for: = replace with: = this tends to fix it Cheers JulieD "Mike" wrote in message ... In an excel sheet, I am typing in a new formula: "=Master!C271". However, instead of showing what is in that cell, it shows the formula. Does anyone know how to fix this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula help | Charts and Charting in Excel | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
Preserve Excel formula entry | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
hyperlink formula | Excel Discussion (Misc queries) |