View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default formatting - aligning decimal points

An underscore followed by a character creates a space the width of that
character. _$
or
Some combinations of ??.?? will align decimal points.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Emily"
wrote in message
Does anyone know the best/most efficient way to customize the number formats
such that you can align the decimal point in a series of numbers in a column
where some numbers use a currency sign and some do not while using a
non-fixed-width font?
Thanks!