Online Video Courses

Plain writing SAVE 50% TODAY!
Learn Plain Writing
------------------------------------ technical writing SAVE 50% TODAY!
Learn Technical Writing
------------------------------------ research paper writing SAVE 50% TODAY!
Write Great Research Paper
------------------------------------ MS Word Power Tips
MS Word Power Tips

Free Download

Learn 7 Reasons Why Becoming a Technical Writer is a Great Career Move!

New Graphic

Every Week! 

Subscriber Counter

We value your privacy. We will not share your information with anyone.

How to Line Up Numbers on Decimal Points in Excel

© Ugur Akinci

Did you have a column of numbers in MS Excel that looked ugly like this:

MS Excel Uncentered Numbers

You can have a really nice looking column of numbers by centering them on the DECIMAL POINT — even if some of them do not have a decimal point.

The first thing to do is to define the same number of decimal points (lets say 2) for all numbers.

Follow these steps:

1) Select your column of numbers and then right click and select Format Cells to display the Format Cells dialog box.

2) Select Numbers from the Category navigation list to display the Sample numbers dialog box. Select “2” decimal places.

MS Excel Uncentered Numbers 2

3) Then, from the same Category list, select Accounting:

MS Excel Uncentered Numbers 3


4) Click OK to close the Format Cells dialog box and display your new and improved column of numbers:

MS Excel Uncentered Numbers 4

Don’t they look much better?

5) If these are prices (assuming you’re in USA, but the method does not change), go back to the Accounting screen and select the “$” Symbol from the drop-down list:

MS Excel Uncentered Numbers 5

6) Click OK to close the Format Cells dialog box and display your new and improved column of numbers with the dollar sign:

MS Excel Uncentered Numbers 6

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>