Format as decimal number

Converts the cell value to a number and adds the specified number of decimals.

Type: Import/Export

This formats the number as it is viewed and does not round it. Any text specified to be removed will be replaced/ignored during the number format.

Example

• Cell value: 12.53 m

• Rule values:

  • Number of decimals: 4

  • Remove text: kg|Kg|g|mg|m|mm|each|L|ml|oz|fl

• Result: 12.5300