Number conversion

[FinChase]

I need to convert a number that is currently formatted as Double to a 7-digit format without decimail points. Using a query, I can create the calculated field to get rid of the decimal point, but I need for the field to be 7 digits long, with leading 0s to make up all 7 digits.

For example, 153.15 should become 0015315. I can only get it as far as being 15315. Is there a way I can set Properties to format this field, or is there another expression I can add to my calculation? I'm multiplying the source field by 100 to get rid of the decimal.

Any help will be appreciated as I'm stuck on this step.

[June7]

Try:
Format(153.15 * 100, "0000000")

[FinChase]

That worked! Thanks so much!