0 ×

Number Formatter

HCS-Tools for KNIME version 4.0.0.v202007151505 by Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)

This node needs one column with the numbers that need to be modified. The node will create a new sortable string column or replace existing one with the formatted numbers so all of them have a constant number of digits.

Number Number Formatted
2 02.00
10.5 10.50
3.33 03.33
The leading character can be chosen:
Leading character Number Formatted
0 02.00
"empty space" 2.00
_ _2.00
Node works only on positive numbers.


Select a column
Choose a column to be formatted
Delete the Source Column
Choose this if you want to dismiss the source columns
Choose the leading character
Choose what kind of character should appear as a leading: "0", "empty space" or "_"

Input Ports

Input port with the table to be formatted.

Output Ports

Output port with the table contained numbers after modification

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME HCS Tools from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.