Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2005
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Zero Pad Field with . in Middle (2003)

    I am trying to zero pad a field with the formula: matter: Left("00000.00000",11-Len([mmatter])) & [mmatter]

    I have a mmatter = 61828.0001 that should be 61828.00010, but when I use this formula, I get 061828.0001

    Is there a workaround for this? Thank you in advance for any recommendations, Norma

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Zero Pad Field with . in Middle (2003)

    You are padding the value on the left, so you won't get zeros on the right. If you want to pad on the right, try
    <code>
    =[mmatter] & Left("00000.00000",11-Len([mmatter]))
    </code>
    Or if you want to format the number, use
    <code>
    =Format([mmatter],"00000.00000")
    </code>
    (If mmatter is a number field, you could actually set the Format property of mmatter itself)

  3. #3
    Lounger
    Join Date
    Jan 2005
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zero Pad Field with . in Middle (2003)

    The FORMAT formula worked beautifully. Thanks much, Norma

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •