Excel number format
 

People, here is the problem I am facing. my excel accepts both number in
"100.00" (hundred) format and "100,00" (hundred ) format. both of them are
numbers in my excel. But when I perform my calucations using both formats it
doesn't calculate anything. I don't like the 100,00 format. how canI get rid
of them? my excell automatically converts all the 100.00 numbers into 100,00
numbers. Please help

Excel number format
 

Select the entire range and do right click and select format
cellsNumberCategoryNumber and give ok.
Still If you see the comma (,) in the cells then select the range and press
Cntrl+H and in Find What: type , (comma) and in Replace With type . (pull
stop) and press Replace All.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Mibrayev" wrote:

People, here is the problem I am facing. my excel accepts both number in
"100.00" (hundred) format and "100,00" (hundred ) format. both of them are
numbers in my excel. But when I perform my calucations using both formats it
doesn't calculate anything. I don't like the 100,00 format. how canI get rid
of them? my excell automatically converts all the 100.00 numbers into 100,00
numbers. Please help