# How to Align Column of Numbers by Decimal Point in Excel

When entering a column of numbers with decimal point, these numbers are aligned right or left by default setting, anyway, they are not aligned by decimal point. If we want to make these numbers aligned by decimal point to make them neatly, we can via Format Cells to customize type of number, then these numbers will be aligned by decimal point properly, this article will show you the details step by step.

Precondition:

First, we need to create a list of numbers. Make sure that all numbers contain decimal point. You can see that above numbers are aligned right by default. In excel Home->Alignment group, you can align text right, left or center, but you cannot align numbers by decimal point.

## Align Numbers in A Column by Decimal Point in Excel

Step 1: Select the list of numbers, then right click to load menu. Click Format Cells on menu. Step 2: On Format Cells, under Number tab, click Custom. Step 3: Under Type enter 0.????. Then click OK. Step 4: Verify that numbers are aligned by decimal point properly. 1. ?’ in ‘0.????’ represents the decimal digit, if you have numbers like 0.23 with only two digits after decimal point, you can enter 0.?? Instead of 0.????. You can enter only one ? or multiple ? per your demands.
2. If you want to align numbers by decimal point, but keep only two decimal digits, you can also enter ‘0.??‘ under Type.
3. You can also enter other type here to align numbers by decimal point. For example, “_-???0.0??;-???0.0??;” or “0.0?;-0.0?”.

Related Posts

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

VBA Macro For VLOOKUP From Another Sheet

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

If Cell is Blank

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

VLOOKUP From Another Sheet Not Working

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you reasons why your VLOOKUP formula is not working ...

If Cell Begins with One of Three Supplied Characters

If you want to test values to see if they begin with some given specific characters like “x”, ”y”, or “z”, you can create a formula with COUNTIF and SUM functions to return results. EXAMPLE You can see “TRUE” or ...

Sidebar