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

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.

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

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

A fixed font lines up perfectly.


--
Kevin Backmann


"sjgiles" wrote:

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.

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

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.

sjgiles wrote:

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.

--

Dave Peterson