Excel number format

[Mibrayev]

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

 

[Ms-Exl-Learner]

Select the entire range and do right click and select format
cells>Number>Category>Number 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!