# Convert digit into word

**URL:** https://forum.kintone.dev/t/convert-digit-into-word/351
**Category:** General
**Created:** [October 19, 2020, 4:33am UTC](https://forum.kintone.dev/t/convert-digit-into-word/351 "2020-10-19T04:33:25Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)
#### Post date: [October 19, 2020, 4:33am UTC](https://forum.kintone.dev/t/convert-digit-into-word/351/1 "2020-10-19T04:33:25Z")

</div>

Hi everyone,

How do you convert&nbsp;the numeric&nbsp;results of your calculations when you need the number displayed in words?

&nbsp;

Converting a number into words isn’t exactly the most straightforward of tasks, but if anyone knows how to do that, please help me.

&nbsp;

thank you …

---

<div class="post-metadata">

### Author: ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)
#### Post date: [October 19, 2020, 5:17am UTC](https://forum.kintone.dev/t/convert-digit-into-word/351/2 "2020-10-19T05:17:17Z")

</div>

Hi there.

You may be able to accomplish your needs using the the Text field’s “Calculate Automatically” option, and using the [IF function](https://get.kintone.help/k/en/user/app_settings/form/autocalc/if_function.html)&nbsp;in the formula.

Try this out in your Kintone environment, and if you get stuck, please update us in this thread with the formula and results/errors you are getting.

---

<div class="post-metadata">

### Author: ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)
#### Post date: [October 19, 2020, 8:13am UTC](https://forum.kintone.dev/t/convert-digit-into-word/351/3 "2020-10-19T08:13:15Z")

</div>

hi Mr. William …

thanks for your reply.

&nbsp;

after i read if function, i dont get want i want. or i just dont understand. i’m sorry,

can u show me simple IF function based on my case ? thank you

---

<div class="post-metadata">

### Author: ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)
#### Post date: [October 19, 2020, 8:17am UTC](https://forum.kintone.dev/t/convert-digit-into-word/351/4 "2020-10-19T08:17:17Z")

</div>

Deni, this forum is here so we can learn from each other.

Please first share what you have tried - the following information would help:

- what fields are you using?
- what field codes are being used?
- what does your formula look like?
- what is the expected result?
- what is the result you got?

---

<div class="post-metadata">

### Author: ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)
#### Post date: [October 19, 2020, 9:16am UTC](https://forum.kintone.dev/t/convert-digit-into-word/351/5 "2020-10-19T09:16:09Z")

</div>

Hello Deni Aldi,

As William mentioned above, please provide more details on your situation and your desired outcome so we can better help you.

Here is a quick demo video to get you started with Kintone's IF function using the Text field's&nbsp;"Calculate Automatically" function, as suggested by William.

[https://youtu.be/RMm3HvwmGg8](https://youtu.be/RMm3HvwmGg8)

Links:

\*&nbsp;[Text field](https://get.kintone.help/k/en/user/app_settings/form/form_parts/text_single-line.html)  
\*&nbsp;[IF Function](https://get.kintone.help/k/en/user/app_settings/form/autocalc/if_function.html)

#### Data Formatting

DATE\_FORMAT(Formula, "Date and time format", "Time zone")

DATE\_FORMAT(Date, "MMM d", "system")

Name&"-"&DATE\_FORMAT(Created\_datetime, "YYYYMMddHHmm", "system")

#### Price Formatting

IF(Price \>= 100, Price/100&" hundred dollars", Price)