How to Get Decimals to Line Up in Excel. If you're using Excel to calculate monetary values, then you only have to worry about two decimal places in your numbers. Aligning your numbers to the ...

There are 3 methods to use the ROUNDDOWN function in Excel to round up numbers, and we have explained all of them in this post.

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.