December 1, 2015
Hi fellow Excel Addict,
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)
If you missed my last newsletter, you can click here to view it online.
How to Align a Column of Numbers on the Decimal Point
If 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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630