Hello again Guys, i'm bothering you this time because i need to make that excel recognize 4' 2" times 24. I have in A1 4' 2" and in B1 24, but when i do the operation in c1 =a1*b1 it would return me an error message (#value) i guess this is because the numbers may be stored as text.
how do i make excel to recognize them as numbers?
what formula can help me in multipy foot and inches times full numbers. I hope you can save me again. Thank you very much mis amigos.
Bookmarks