how can I multiply 7feet and 6ft 8in?

E

epout

How can I multiply 7feet and 6ft 8in using Excel?

I have 7' in A1 column, 6' 8" in B1 column.
When I did =a1 * b1, I get #VALUE! I stretched the column wide
hoping the #VALUE! will disappear and figure comes out. NOPE. Why?

Please help the beginner
 
B

Barb Reinhardt

It's probably because you are multiplying something that's text. Why not
convert to inches and put the format in with CELL FORMAT.
 

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

Similar Threads

how can I multiply a column by only one cell? 4
Replacing A Column Of Numbers 2
Column multiplied by a matrix 2
sum values from range of cells if cells correcponding have the sam 15
Help with determining # of days from certain dates 2
What Am I Doing Wrong Re Some Simple Math On A Column ? 2
IF AND OR STATEMENT 3
how to convert grades into a value 5

Top