How to Get Decimals to Line Up in Excel. If you're using Excel to calculate monetary values, ... For these cases, you have to do custom formatting to line up the decimal points.

By default, Excel displays percentages as integers (whole numbers with no decimal places), meaning if you type 0.549, the cell will display 55%.

Those who are using the desktop version of Excel, have the option to create custom decimal rules by using the Number Format option. From within your spreadsheet, go to the Home tab. Look to the ...

To format numbers in Thousands, Millions, or Billions in Excel, follow these steps: Open the Excel spreadsheet and select cells. Right-click on the selected cell and choose the Format Cells option.

How to Format Debits and Credits in Excel. When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance.

Hello all. I've been working on this for awhile but I'm stumped and putting this out to 'The Hive'. I have a report that prices bonds in the old tick format (i.e 101-10 for 101 and 10/32nds). When ...