There are different ways in Excel to remove decimals and shorten numeric values. In this article, Quantrimang.com will explain how to use the TRUNC function and point out what makes it different from ...

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.

Automatically add decimals to cells Sometimes when you paste a bunch of cells into Excel, it will remove decimals and ruin your data. You can tell Excel to add them as you either enter data or paste ...

By placing a zero before the decimal, the number is more readily recognized as less than one. By configuring a custom number format you can tell Excel to remove leading zeros.

Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

You can prevent Excel from converting numbers to scientific notation. This post shows how to remove scientific notation in Excel.