# Converting Numbers that are k/m etc

**URL:** <https://forum.knime.com/t/converting-numbers-that-are-k-m-etc/24671>\
**Category:** KNIME Analytics Platform\
**Created:** [June 18, 2020, 2:52pm UTC](https://forum.knime.com/t/converting-numbers-that-are-k-m-etc/24671 "2020-06-18T14:52:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nxfxcom](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/n/4af34b/32.png) [@nxfxcom](https://forum.knime.com/u/nxfxcom)\
**Post date:** [June 18, 2020, 2:52pm UTC](https://forum.knime.com/t/converting-numbers-that-are-k-m-etc/24671/1 "2020-06-18T14:52:38Z")

</div>

Hello,

could we extend the string to number node to allow for conversion like:  
63.3k into 63,300 etc?

Thank you

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [June 18, 2020, 5:09pm UTC](https://forum.knime.com/t/converting-numbers-that-are-k-m-etc/24671/2 "2020-06-18T17:09:04Z")

</div>

Use String Manipulation to create new column without k as Double. Then, use Rule Engine to return Value or Value \*1000 if original column is like “\*k”.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [December 18, 2020, 5:21am UTC](https://forum.knime.com/t/converting-numbers-that-are-k-m-etc/24671/3 "2020-12-18T05:21:49Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.