# CALC - Point by a comma

**URL:** <https://forum.collaboraonline.com/t/calc-point-by-a-comma/1892>\
**Category:** Calc\
**Created:** [June 16, 2023, 11:54am UTC](https://forum.collaboraonline.com/t/calc-point-by-a-comma/1892 "2023-06-16T11:54:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicod24](https://avatars.discourse-cdn.com/v4/letter/n/f17d59/32.png) [@Nicod24](https://forum.collaboraonline.com/u/Nicod24)\
**Post date:** [June 16, 2023, 11:54am UTC](https://forum.collaboraonline.com/t/calc-point-by-a-comma/1892/1 "2023-06-16T11:54:07Z")

</div>

Good morning  
I want to replace in the collaborative tool the point by a comma when marking a numeric value in the cell.  
I can’t find it in the options or even changing the language.  
THANKS  
version COOLWSD :21.11.5.3

---

<div class="post-metadata">

**Author:** ![mmeeks](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/mmeeks/32/371_2.png) [@mmeeks](https://forum.collaboraonline.com/u/mmeeks)\
**Post date:** [June 16, 2023, 2:08pm UTC](https://forum.collaboraonline.com/t/calc-point-by-a-comma/1892/2 "2023-06-16T14:08:58Z")

</div>

Nico - a good question; this is almost certainly a property of the language that is set for the document; you can often change that in the status bar for the whole document; or even for a range of text. To change the default - it’s necessary to either tweak the templates - or ensure that your language is changed before creating the document. Hope that helps.

---

<div class="post-metadata">

**Author:** ![Tex](https://avatars.discourse-cdn.com/v4/letter/t/eb8c5e/32.png) [@Tex](https://forum.collaboraonline.com/u/Tex)\
**Post date:** [June 22, 2023, 1:04am UTC](https://forum.collaboraonline.com/t/calc-point-by-a-comma/1892/3 "2023-06-22T01:04:57Z")

</div>

Hey @Nicod24,

Welcome to the forum. 🙂

> I want to replace in the collaborative tool the point by a comma when marking a numeric value in the cell. I can’t find it in the options […]

So, you wanted to change numbers like:

- `123.45` → `123,45`
- `678.90` → `678,90`

where your decimal place would go from using a `.` (period) to a `,` (comma)?

This can be done by

### A. Using the Mouse

- Highlight your cells.
- **Right-Click \> Format**

### B. Using the Menus

- Go to “Format” Tab.
- Press “Format Cells” button.

Both of these will lead you to the “Format Cells” window + “Numbers” tab, which would look like this:

 ![Collabora.Office.23.05.Calc.-.Format.Cells.-.Numbers.Tab](https://europe1.discourse-cdn.com/flex013/uploads/collaboraonline/original/1X/e4169982bc1f8d416e989bc1073278fdd29771a2.png)

From there, you can adjust your Language (or number formatting) as usual.

* * *

For example, if you changed the “Language” dropdown from:

- `English (USA)` → `German (Germany)`

you would get the COMMA instead of PERIOD.

* * *

And, like mmeeks said, you could do some more document-wide changes instead… but hopefully the above instructions fix your problem. 🙂