View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing !

"Joanne" wrote:
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 -----

"Joanne" wrote in message
...
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 ???