Formula snafu

E

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
 
J

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

Dave Peterson

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

(Repeat for the other cell)
 
E

El Bee

Thanks John and Dave; this fixed the problem.

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

(Repeat for the other cell)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top