View Single Post
  #3   Report Post  
SteveG
 
Posts: n/a
Default Text to Columns ???


Rick,

You can format the cells as:

0.00____ (four underscores)

This will give the appearance that the numbers are centered with the
decimals lined up. Switch from Center Align to Right Align. Highlight
and right click on the cells you wish to format. Format Cells/Custom
and type the above in the Type field.

There may be a better way but that seemed to work for me.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=482871