Formatting for just decimal

r. howell · Nov 30, 2004

Is there any way to get a number to display just the decimal portion? That
is, I do not want 0.03 but .03? Thanks

Wayne Morgan · Nov 30, 2004

I tried this from the Immediate window, does it help?

?Format(0.22, ".##")
..22

fredg · Nov 30, 2004

Is there any way to get a number to display just the decimal portion? That
is, I do not want 0.03 but .03? Thanks

Set the format of the control to:
#.00

r. howell · Dec 1, 2004

Many Thanks. The hours you folks save are gratefully appreciated.