Difference between revisions of "Documentation/FAQ/Calc/Formatting/How can I use a dot (.) as decimal sign instead of a comma?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
(New page: {{DISPLAYTITLE: How can I use a dot (.) as decimal sign instead of a comma?}} <section begin=question/> '''How can I use a dot (.) as decimal sign instead of a comma?''' <section end=ques...) |
(added remark on the use of styes) |
||
| Line 15: | Line 15: | ||
# Select '''Format - Cells''' from the menu | # Select '''Format - Cells''' from the menu | ||
# Select the '''Numbers''' tab and select one of the English variants from the '''Language''' list. | # Select the '''Numbers''' tab and select one of the English variants from the '''Language''' list. | ||
| + | |||
| + | You can also (and probably better) achieve this by changing the properties of cell style '''default'''. | ||
| + | That will automatically change that property for all other styles (unless changed explicitly in a another style). | ||
'''Notes:''' | '''Notes:''' | ||
Revision as of 09:22, 9 March 2010
How can I use a dot (.) as decimal sign instead of a comma?
Some languages, like French, Italian, German, or Portuguese, use a comma as decimal separator. The appearance of numbers in Calc depends on the language settings. If you want to use the dot or decimal point as separator you need to switch the language for the corresponding cells to English:
- Select the corresponding cells (press CTRL+A to select all cells of a sheet)
- Select Format - Cells from the menu
- Select the Numbers tab and select one of the English variants from the Language list.
You can also (and probably better) achieve this by changing the properties of cell style default. That will automatically change that property for all other styles (unless changed explicitly in a another style).
Notes:
- If you use a dot in a language that uses a comma as decimal separator, Calc will not recognize the input as number.
- The decimal sign used will change with the language. If you switch back to a language that uses the comma as separator, the displayed decimal separator will change accordingly.
