decimal to string

[Brian]

Hello all, I need a function that will take
$6425.00 and make it 000642500 It always has to produce 9 characters so
for instance $23.22 would look like 000002322 This is for some state
reporting and will not take it any other way. TIA

 

[Douglas J. Steele]

Format([MyValue]*100, "000000000")

 

[Brian]

thank u much worked like a charm