Decimal alignment

  • Thread starter Thread starter Vinod
  • Start date Start date
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.
 
The only way I know is to convert them to text and then enter a space s
everything aligns properly.

Michae
 
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.
 
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 "#,###.???"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top