How do I align decimals in Excel when not all numbers have % sym.

S

sjgiles

I have a chart, 3 columns wide, 11 rows deep. The first and last numbers of
each column is a percentage, showing the % sign. The rows in between are
also decimals, (1 decimal shown), but no % sign. Is it still possible to
align these numbers by the decimals? I've tried everything I know of.
 
K

Kevin B

Using this custom format gets close with a proportional spaced font: #0.00_)

A fixed font lines up perfectly.
 
D

Dave Peterson

I would have used the % character:
#0.0_%

The underscore says to reserve room for the next character, but don't show it.

And you might have to adjust the format for the percentages, but you didn't
share the number of decimals for those.
 

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

Similar Threads

alignment with decimals & % sign 5
How do I center numbers in a cell, but align by decimal? 2
How to Anchor Decimal in Text Box 1
aligning by decimal point - negative and positive numbers 3
How do I align currency decimals in cells? 2
how do I align numbers with the decimal in a table column ? 1
Merging from an Excel file with graphics 1
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2

Top