Outline different number formats

[glasbergenm]

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?

[hans bal(nl)]

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
>
>

[glasbergenm]

Because in some cases, a decimal number is nonsence. For example, a number of people looks a bit odd when showing them as 30.00.

[Dave Peterson]

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