Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula snafu
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula snafu
They are probably formatted as text. Select the cells, go to Format, change
to General, then go to each formula, press F2, then Enter. -- John C "El Bee" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula snafu
Select the offending cell
Format it as General (or anything but text) Then reenter the formula (Repeat for the other cell) El Bee wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula snafu
Thanks John and Dave; this fixed the problem.
"Dave Peterson" wrote: Select the offending cell Format it as General (or anything but text) Then reenter the formula (Repeat for the other cell) El Bee wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula snafu
You're welcome, and thanks for the feedback :)
-- John C "El Bee" wrote: Thanks John and Dave; this fixed the problem. "Dave Peterson" wrote: Select the offending cell Format it as General (or anything but text) Then reenter the formula (Repeat for the other cell) El Bee wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula snafu | Excel Discussion (Misc queries) | |||
Toolbars macro buttons snafu | Excel Discussion (Misc queries) | |||
sumproduct snafu | Excel Discussion (Misc queries) | |||
sumproduct snafu | Excel Discussion (Misc queries) |