Outline different number formats

G

glasbergenm

I'm trying to outline an column with different number formats, so tha
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 al
aligned left in the post :) )

Can anyone help me
 
H

hans bal(nl)

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

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

HTH
 
G

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

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