ExcelBanter - Aligning data with varying decimal places

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Aligning data with varying decimal places (https://www.excelbanter.com/excel-discussion-misc-queries/12567-aligning-data-varying-decimal-places.html)

edpaul

Aligning data with varying decimal places

I have a column of cells in which the data include various numbers of decimal
places. Is there a way to align the data vertically so that the decimals
line up, without adding trailing zeroes?

JE McGimpsey

one way:

Format/Cells/Number/Custom 0.???

In article ,
edpaul wrote:

I have a column of cells in which the data include various numbers of decimal
places. Is there a way to align the data vertically so that the decimals
line up, without adding trailing zeroes?

All times are GMT +1. The time now is 11:14 AM.