View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mibrayev Mibrayev is offline
external usenet poster
 
Posts: 1
Default 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