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