On excel, my formula will not calculate and add info into cell

[Kara D. Sanders]

I'm having problems getting a formula to enter the sum into a cell, I am
working on multiple worksheets and my formula is multiplying a cell on one
worksheet with a cell on a seperate worksheet. It allows the formula in the
cell but wil not supply the answer. Any help?

[Alan]

Probably the cell the formula is in is formatted as text, try entering 1 in
an empty cell, copy it and then Paste Special > Multiply into the offending
cell,
Regards,
Alan.
"Kara D. Sanders" <Kara D. Sanders@discussions.microsoft.com> wrote in
message news:E5A6AE59-00EA-4719-83C9-09814D1C7ACB@microsoft.com...
> I'm having problems getting a formula to enter the sum into a cell, I am
> working on multiple worksheets and my formula is multiplying a cell on one
> worksheet with a cell on a seperate worksheet. It allows the formula in
> the
> cell but wil not supply the answer. Any help?

[Kara D. Sanders]

Thank you, hopefully it works.

"Alan" wrote:

> Probably the cell the formula is in is formatted as text, try entering 1 in
> an empty cell, copy it and then Paste Special > Multiply into the offending
> cell,
> Regards,
> Alan.
> "Kara D. Sanders" <Kara D. Sanders@discussions.microsoft.com> wrote in
> message news:E5A6AE59-00EA-4719-83C9-09814D1C7ACB@microsoft.com...
> > I'm having problems getting a formula to enter the sum into a cell, I am
> > working on multiple worksheets and my formula is multiplying a cell on one
> > worksheet with a cell on a seperate worksheet. It allows the formula in
> > the
> > cell but wil not supply the answer. Any help?
>
>
>

[Niek Otten]

<hopefully it works>

I don't think it will. This works for constants, not for formulas.
Format the cell as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten

"Kara D. Sanders" <KaraDSanders@discussions.microsoft.com> wrote in message
news:D9245822-A7A2-4711-9926-5C418F9A6FBE@microsoft.com...
| Thank you, hopefully it works.
|
| "Alan" wrote:
|
| > Probably the cell the formula is in is formatted as text, try entering 1 in
| > an empty cell, copy it and then Paste Special > Multiply into the offending
| > cell,
| > Regards,
| > Alan.
| > "Kara D. Sanders" <Kara D. Sanders@discussions.microsoft.com> wrote in
| > message news:E5A6AE59-00EA-4719-83C9-09814D1C7ACB@microsoft.com...
| > > I'm having problems getting a formula to enter the sum into a cell, I am
| > > working on multiple worksheets and my formula is multiplying a cell on one
| > > worksheet with a cell on a seperate worksheet. It allows the formula in
| > > the
| > > cell but wil not supply the answer. Any help?
| >
| >
| >