# Convert numbers into Accounting format/ comma seperated

**URL:** <https://forum.knime.com/t/convert-numbers-into-accounting-format-comma-seperated/45320>\
**Category:** KNIME Analytics Platform\
**Created:** [July 21, 2022, 11:19am UTC](https://forum.knime.com/t/convert-numbers-into-accounting-format-comma-seperated/45320 "2022-07-21T11:19:43Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [July 29, 2022, 6:00am UTC](https://forum.knime.com/t/convert-numbers-into-accounting-format-comma-seperated/45320/8 "2022-07-29T06:00:32Z")

</div>

@helpmeplease I think you can have the accounting format in knime only as string since knime will use its own internal storage of numbers. If you want to have this format in Excel. Maybe the way to go forward would be to just export the regular numbers and then change the _format_ in Excel:

> [@Excel Formating](https://forum.knime.com/t/excel-formating/44593/2):
>
> @helpmeplease welcome to the KNIME forum. I am not sure there is a consistent introduction about the [Continental nodes](https://hub.knime.com/continental_knime_extension_developer/extensions/com.continental.knime.feature/latest). I have [not done much with them](https://kni.me/w/FLsPoDBusoKLMTWb) but it seems you have to grasp the concept of this “[control table](https://kni.me/w/Lq4X1-_FKKDtlSTF)” it seems. Then there is the free book “From Excel to KNIME” which also has a chapter about Continental nodes. This also might be a good pint to start understanding the concept. the book is also available in other languages like German, Spanish and Portuguese: Ano…

Another approach to this could be to use Python and [Openpyxl](https://hub.knime.com/search?type=Workflow&tag=openpyxl&sort=maxKudos) like [this](http://www.whiteboardcoder.com/2020/02/openpyxl-number-format.html) - but maybe you start with the Continental nodes. I can see if I can come up with an example.

---

_[View the full topic](https://forum.knime.com/t/convert-numbers-into-accounting-format-comma-seperated/45320)._
