ExcelBanter - How do I change #VALUE!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I change #VALUE! (https://www.excelbanter.com/excel-worksheet-functions/122358-how-do-i-change-value.html)

q''n on OL express

How do I change #VALUE!

I am trying to do a simple cal ex: e2*f2 but the product in the cell apears
#VALUE!
how do I change this and get the number ...pls help .
--
:( ............:)

John Bundy

How do I change #VALUE!

Are they both formated as numbers?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"q''n on OL express" wrote:

I am trying to do a simple cal ex: e2*f2 but the product in the cell apears
#VALUE!
how do I change this and get the number ...pls help .
--
:( ............:)

All times are GMT +1. The time now is 04:05 PM.