Number Formating

[Silas Selekane]

Hello,

How can i change number "1,002" to 1002 as when i multiply the number i get #VALUE error.

Thanks in advance

 

[NARAYANK991]

Hi ,

What is the thousands separator in your Excel ?

If at all the number 1002 has been entered as text , it can be converted to a numeric value by adding 0.

Thus if your value of 1002 is in A1 , and you wish to multiply this by the value in B1 , then instead of :

=A1 * B1

use :

=(A1 + 0) * B1

However , the very fact of multiplying A1 by B1 should give you a valid numeric result , and not the #VALUE! error.

Narayan

 

[Silas Selekane]

Thanks NARAYANK991, i tried the above but didnt work. I used the Substitude Text Formula http://chandoo.org/excel-formulas/substitute.shtml.

Thanks.http://chandoo.org/forum/members/narayank991.1512/

 

[Debraj]

Did you tried..

Find & Replace "," to ""