Excel number format

  • Thread starter Thread starter Mibrayev
  • Start date Start date
M

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
 
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!
 
Back
Top