Change number of digits to 5

[bowes884]

have a query with a field that contains numbers with 3,4,and 5 digits. I want to format it so it displays all as 5 digits by adding 0s to the front of the number. EX:

324
4856
45634

change to:
00324
-4856
45634

Help please. Dont want to do it in VBA either. I would rather build it as an expression field or something.

 

[Mile-O]

Format([MyValue], "00000")