Rounding off / forcing zeros to show..

[basepointdesignz]

When rounding off a figure to 3 decimel places, if the figure last decimel place is a 0, then it doesn't display. Is there a way to force zeros to display?

ie: +12.98 is what is shown, but +12.980 is what i want it to show..



Cheers,

Paul
basepointdesignzltd..
P4 3.0Ghz / 1.25GB RAM
XP Pro SP2
Sapphire X1950 512MB Dual-DVi Graphics Card..

 

[Andrzejek]

Try:

Debug.Print Format(12.98, "#####[blue]0.000[/blue]")

Have fun.

---- Andy

 

[PHV]

format(12.98,"+0.000;-0.000")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[basepointdesignz]

+12.98 was just an example, the figure will be different in all cases. Can i just replce the +12.98 bit with the variable name?
ie:

Debug.Print Format(Y, "#####0.000")

Cheers,

Paul
basepointdesignzltd..
P4 3.0Ghz / 1.25GB RAM
XP Pro SP2
Sapphire X1950 512MB Dual-DVi Graphics Card..

 

[VRoscioli]

That should work just fine.

-V

 

[PHV]

format(Y,"+0.000;-0.000")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886