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:
Is there any way of achieving this using a built-in function?