Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: Just a little expression

    Hello,

    I need some help with a function which seems simple enough but this long day at the office has burnt a few bridges in my brain (especially after messing with Access all day! ) and i can't find a logical solution.
    I want to insert 0s in front of the "Line" number, it has to be in expression form because it needs to be under the same format with other orders.


    Line Wanted result
    10 0010
    100 0100
    15 0015
    200 0200
    20 0020
    27 0027
    5 0005

    Thank you !

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Just format the column to show N digits with leading zeros.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    =right("0000" & a1, 4)
    George
    Home | Blog

Posting Permissions

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