# Spanish format (1.234,56)

**URL:** <https://community.make.com/t/spanish-format-1-234-56/26571>\
**Category:** Beginner Questions\
**Tags:** google-sheets, functions\
**Created:** [February 6, 2024, 1:52pm UTC](https://community.make.com/t/spanish-format-1-234-56/26571 "2024-02-06T13:52:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lrodrigue443](https://avatars.discourse-cdn.com/v4/letter/l/49beb7/32.png) [@lrodrigue443](https://community.make.com/u/lrodrigue443)\
**Post date:** [February 6, 2024, 1:52pm UTC](https://community.make.com/t/spanish-format-1-234-56/26571/1 "2024-02-06T13:52:26Z")

</div>

Hello Make Community,

I recently registered and need some assistance with a specific formatting task. I’m trying to convert a number from the English format (e.g., 1,234.56) to the Spanish format (1.234,56) using the Text Parser module in Make. I’ve attempted a few configurations but haven’t been successful yet. Could anyone provide guidance or share an example of how to set up the Text Parser module correctly for this purpose? Any help or tips would be greatly appreciated!

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [February 6, 2024, 3:19pm UTC](https://community.make.com/t/spanish-format-1-234-56/26571/2 "2024-02-06T15:19:39Z")

</div>

Welcome to the Make community!

You can use the built-in function `parseNumber` and `formatNumber`

E.g.:

```auto
{{ formatNumber(parseNumber("1,234.56"; "."; ","); 2; ","; ".") }}

```

![Screenshot_2024-02-06_230243](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/1/513cf78aaa8a89be1755f334f77126f2ae4acb6c.png)

### Output

![Screenshot_2024-02-06_230252](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/9/59d2e4d948bc13d554d7b9448a2368a6e0214244.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [April 29, 2024, 3:49pm UTC](https://community.make.com/t/spanish-format-1-234-56/26571/3 "2024-04-29T15:49:58Z")

</div>