Leading Zeroes

  • Thread starter Thread starter Linda
  • Start date Start date
L

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
 
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")
 
Back
Top