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

Thanks for the idea MrShorty.
But, your solution doesn't seem to work for the 7.94** ???

Here's my actual data:

7.94**
(139.63)
10.47
18.18
(7.87)


"MrShorty" wrote:


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