for a banking export report i need to turn a number into 10 character text with leading and trailing zeros
so 756.23 becomes 000075623
500.00 becomes 0000050000
8555.10 beciomes 000085510
i cant seem to get it done
any help is appreciate
thanks
rick