View Single Post
  #2   Report Post  
MrShorty
 
Posts: n/a
Default Aligning Decimal Points with non-numeric data


This format code (Format-Cells-Number tab-Custom) seems to work for
me.
0.00_*_*_);(0.00)_*_*;0.00_*_*_);@_)
Make sure the alignment is set to right.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=484328