Formula snafu

[El Bee]

I have 2 formulas; one works and the other doesn't. The second one displays
as text and not a formula. Can someone tell me what to look for?

Formula 1 : =Sheet1!B2&", "&Sheet1!C2 : it shows the persons last name,
first name

Formula 2: =Sheet1!D2 : it shows =Sheet1!D2 (it should be a number 80101)

There are 4 formulas on this row which look at the same row of the
worksheet. Two of these formulas work and the other to do not; they just
display the formula.

Thanks,

El Bee

 

[John C]

They are probably formatted as text. Select the cells, go to Format, change
to General, then go to each formula, press F2, then Enter.

 

[Dave Peterson]

Select the offending cell
Format it as General (or anything but text)
Then reenter the formula

(Repeat for the other cell)

 

[El Bee]

Thanks John and Dave; this fixed the problem.

Select the offending cell
Format it as General (or anything but text)
Then reenter the formula

(Repeat for the other cell)

 

[John C]

You're welcome, and thanks for the feedback