| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suddently when we type in . (dot or point) become comma in excel
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Suddently when we type in . (dot or point) become comma in excel
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... "geniusideas" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when I type numbers in a cell it changes it to a decimal point | Excel Discussion (Misc queries) | |||
| ALL NUMBERS I TYPE HAVE DECIMAL POINT | Excel Discussion (Misc queries) | |||
| using text wrap how can I type over the page break point | Excel Worksheet Functions | |||
| Decimal point/comma issue | Excel Discussion (Misc queries) | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Hybrid Mode
