To post as a guest, your comment is unpublished.· 1 years agoI've been looking for an answer to that question for a good while. I need a way to do this with custom number formatting and haven't found a solution. I don't have to say that often with Excel, but I don't think it's possible.
How to align column of numbers by decimal point in Excel?
Sometimes, we need to align the numbers by decimal point in a column in worksheet to make the numbers more neatly and beautifully as following screenshot shown.
In Excel, we can align the column of numbers by decimal point by using the Format Cells function. In this article, you will get the details.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To align the column of numbers by decimal point in Excel, please do as follows:
1. Select your numbers list which you want to align them by decimal point.
2. Right click, and choose Format Cells from the context menu, see screenshot:
3. Then, in the Format Cells dialog box, click Custom under Number tab, and enter this 0.???? into the Type box, see screenshot:
Note: The ? stands for the number of your decimal digits, it depends on your largest decimal digits. If the highest decimal places is 5, you just need to enter five question marks as you need.
4. Then click OK to close this dialog, the numbers in the selected cells will line up on the decimal point for left, center and right alignment. See screenshot:
Note: If your data contains the whole numbers, they will be added a dot mark after the whole number.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 years agoAny way to get rid of the decimal for whole numbers?