Results 1 to 3 of 3

Thread: Padding with zeros

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 1999
    Posts
    51

    Post

    What is the easiest way to pad an 11 digit field with 0's?

    Thank you.

  2. #2
    Fanatic Member coox's Avatar
    Join Date
    Oct 1999
    Posts
    550

    Post

    Why not just use:

    MyString = Right("00000000000" & MyString, 11)

  3. #3

    Thread Starter
    Member
    Join Date
    Jul 1999
    Posts
    51

    Post

    Thanks. That worked great.

Posting Permissions

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



Click Here to Expand Forum to Full Width