Can you show the decimal point all the time?

If yes, try:

#,##0.????
or
0.????

Use as many ???? as your worst decimal has.


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

--

Dave Peterson