View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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.