L
Louise
i am trying to enter a formula in a cell, but it is coming up as a value.
how do i change it from value to formula.
how do i change it from value to formula.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gilbert
Isn't the formula supposed to return a value? Maybe something in the
conditional formatting.
conditional formatting.
×
מיכ×ל (מיקי) ×בידן
Precede the formula with an apostrophe
Micky
Micky
B
Bob I
(Excel 2007) Click Formulas tab, then Show Formulas
R
Reeza
i am trying to enter a formula in a cell, but it is coming up as a value.
how do i change it from value to formula.
Use the apostrophe at the beginning or CTRL+ ~ used to show all
formula's in a worksheet. Useful for checking things.