Align Decimals

For numbers with varying decimals places, right click the range and select Format Cells, Number, Custom

Use this format

0.???

Match the number of question marks to the maximum number of decimal places used.



© Copyright andrewsexceltips.net All Rights Reserved.