ExcelBanter - enter a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - enter a formula (https://www.excelbanter.com/excel-discussion-misc-queries/261099-enter-formula.html)

Louise[_3_]

enter a formula

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.
--
Louise

GILBERT

enter a formula

Isn't the formula supposed to return a value? Maybe something in the
conditional formatting.

"Louise" wrote:

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.
--
Louise

מיכאל (מיקי) אבידן

enter a formula

Precede the formula with an apostrophe
Micky

"Louise" wrote:

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.
--
Louise

Bob I

enter a formula

(Excel 2007) Click Formulas tab, then Show Formulas

Louise wrote:

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.

Reeza

enter a formula

On Apr 9, 6:36*am, Louise wrote:
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.
--
Louise

Use the apostrophe at the beginning or CTRL+ ~ used to show all
formula's in a worksheet. Useful for checking things.

All times are GMT +1. The time now is 10:15 AM.