FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

December 1, 2015

TheExcelAddict.com Quote of the Day
"Whenever you find yourself on the side of the majority,
it is time to pause and reflect."
-- Mark Twain --


Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)Welcome to December. Today in eastern Newfoundland, we have our first snowfall of the season.

I know it's pretty to look at but it's also pretty cold outside today. However, the thing about here is that this snow won't stick around for very long.

Our weather frequently switches between mild and cold, until mid-winter (late January) when it will stay cold for a couple of months. Until then, there will be constant freezing and thawing and we'll be lucky if we get a white Christmas.

Hoping wherever you are, you'll have a great December whether that means snow and cold or sun and heat.

Keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

How to Align a Column of Numbers on the Decimal Point

Numbers Aligned On Decimal in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365If you need to align numbers with varying numbers of decimal places in a column, here's an easy trick you can use.

Say, for example, you want to line up all the decimals for 1.23, 4, .0056, 7890.1, and -2.3. First you determine the maximuim number of places after the decimal point in the list. In this case it is 4 (i.e. .0056).

Now you create a custom number format that adds placeholders for that many digits after the decimal whether it includes a number or not.

To format these numbers exactly as entered but have all the decimal points aligned in the column, use the following number format...

.????

The question mark (?) in the number format code represents a single digit. If the value in the cell doesn’t require all of the digits in the code, a blank space will be displayed instead.

Align Numbers On Decimal in Microsoft Excel 2003, 2007, 2010, 2013, 365



Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.co

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630