Suddently when we type in . (dot or point) become comma in excel

  • Thread starter Thread starter geniusideas
  • Start date Start date
G

geniusideas

Hi,

I have problem with my excel 2000, when we type in . (dot) it
return , (comma). This only happen when we use dot under the number at
your keyboard(right). When we use dot under the letter (center) it
can't be use as a decimal point for example when we type in .5 in any
cell normally your excel automatically return to 0.5. Now any formula
related to decimal point can't be use. Pls help why thing happen and
how to solve this problem..
URGENT PLSSSS..

http://xlsblog.com
 
Looks like your Decimal Separator and Thousand Separator have been setup like
that either in Excel or your system..
To change -
(Not sure about 2000 but in) Excel 2003 the navigation is
Tools->Options->International Tab -> Number Handling Group...
You can specify Decimal Separator and Thousand Separator or opt to use the
System separators

To change the system settings on Windows Computers go to Control Panel ->
Regional Settings...
 
Back
Top