Decimal alignment

V

Vinod

Five data points

75.5
13.4
34.4
90.8
9.3

The column of cells is centered. Is there a way to align the 9.3's
decimal with the above data points?

Thanks in advance.
 
D

daniels012

The only way I know is to convert them to text and then enter a space s
everything aligns properly.

Michae
 
T

tjtjjtjt

Format the cells to have a set number of decimal places. If you type 9.3 and press Enter, it will display as 9.30.
 
D

David McRitchie

Why were numbers centered in the first place.
A number format with decimal would make them line up.
Format, cells, number, ...
or custom "#,###.0"
or if you don't want to show fractional values but
have decimals align "#,###.???"
 
Top