Displaying Number Value As String but need to add zeros

[random621]

I have a field {table.price} that displays numbers such as below:
4.2
4.25
13.1
13.15
13

In need to display these number values as a string based on the following conversion:
4 = 0400
4.2 = 0420
4.25 = 0425
13.1 = 1310
13.15 = 1315
13 = 1300

{table.price} represents any value from 0.01 cents to 99.99 cents.

I've tried the simple cstr formula but that returns usually 4 or if I modify the number format I can get 4.20.

Your help is appreciated!

 

[AndyMc]

Random621,

Try:

totext(({table.price}*100),"0000")

Andy

 

[random621]

Andy -

Thanks. Worked perfectly.

Ryan