Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Bradford, Yorkshire, England
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing Leading Zeros (2K )

    I have a mailmerge document that contains an application number with leading zeros. Is it possible to format this field so that the leading zeros are removed.

    eg 000255555 will be printed as 255555

    Thanks for any help

    Mich

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

    Re: Removing Leading Zeros (2K )

    Try the following:
    - Click anywhere in the merge field.
    - Press Shift+F9 to show field codes.
    - You should see something like { MERGEFIELD Fieldname }
    - Insert # 0 before the closing bracket.
    - The field should now look like { MERGEFIELD Fieldname # 0 }
    - Press F9 to hide the field codes and update the field.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Bradford, Yorkshire, England
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Leading Zeros (2K )

    Hi Hans

    Thanks very much, you are a star

    Mich

Posting Permissions

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