Function that writes a specified character

[mrfritz44]

Was wondering if tere is a way to format a right justified decimal with leading zeros?

If my DECIMAL = 23.01 and I use Format(DECIMAL,"0000000000") then
I get:
0000000023
and not the
0000023.01
that I need.

Any clues on what I can do to get those leading zeros and maintain my decimal at the same time?

Thanks,

Fred

 

[Golom]

How 'bout

Format(DECIMAL,"0000000000.00")

 

[mrfritz44]

I'm embarrassed........thank you.