Leading Zeroes

[Linda]

I have a field that must always be 14 characters. It is a dollar field. How
do I add the leading zeros when the dollars are variable lengths?


Linda Thanks

 

[Ken Snell]

You can use the format function to "add" zeroes to a number. Assume that
your currency value is $53.44. You'd use this expression to get 14
characters total (including the decimal point):

Format("53.44", "00000000000.00")