Number Formatting

1

I want to format a number to have leading zero’s to achieve a consistent display format in a label or text box. For example:

1 should be formatted to 001
10 should be formatted to 010

The reason for this is so my app can follow standard formatting for latitude and longitude values. In Visual Basic I use format$(myNumber, ”000”) which achieves this. For a longitude of 1 degree and 4.6 minutes west, I would like to display:

W001 04.6

Is there any way of achieving this using a built-in function?

2

How about this?

n = 1
x = Right(1000 + n, 3)
3

Thanks; that works!