My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing !

J

Joanne

I'm discouraged ... have been trying to create a very simple inventory sheet
on Excel. Addition works just fine ... but multiplication just won't work.

I want to multiply the number in cell C3 by the number in cell D3. I want
the answer in E3 ... so I have positioned myself in E3, typed (=C3*D3) and
pressed ENTER. Nothing ! All I'm left with in E3 is =C3*D3 ... no product !

I had no problem with my Excel 2000 ... What's up with this Office Home &
Student 2007 ???
 
J

JoeU2004

Joanne said:
All I'm left with in E3 is =C3*D3

The cell was probably formatted as Text before you entered the formula.

Format the cell as General or any numeric format. Then press F2 and press
Enter.


----- original message -----
 
G

Gord Dibben

You could have display options set to show formulas.

Hit CTRL + ` to toggle view formulas on/off.

Or the cell may be pre-formatted as Text.

Try change format to General then F2 and Enter


Gord Dibben MS Excel MVP
 

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