Why not use a number format with a fixed number of decimals ?

300,00
1,25
20,20
1000,00

HTH

"glasbergenm" wrote:


I'm trying to outline an column with different number formats, so that
the (in some cases virtual) comma is always on the same place.
Example:

_300
___1.25
__20.2
1000

(the underscores replresent blanks, but without them, they are all
aligned left in the post :) )

Can anyone help me?


--
glasbergenm
------------------------------------------------------------------------
glasbergenm's Profile: http://www.excelforum.com/member.php...o&userid=31001
View this thread: http://www.excelforum.com/showthread...hreadid=550251