Leading zeroes
Leading zeroes
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Leading zeroes

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I keep the leading zeroes in the zip codes of databases that I save in ascii text?
    Formatting them as text or zip codes or general doesn't do it.

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about a leading space? Almost any text character will do. The nice thing about a leading space is that it doesn't get in your way if you are printing the data or using it for mail merge.

    You can also just turn it into text instead of a number using the text function. It still sorts properly. As text, Excel will want to left align instead of right align.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 10:56, David Hamacher wrote:
    How do I keep the leading zeroes in the zip codes of databases that I save in ascii text?
    Formatting them as text or zip codes or general doesn't do it.
    Why have you concluded that the Zipcode formatting doesn't preserve the leading zeroes when saving as a Tab-delimited text file (.txt)? It works for me!

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try custom format 00000
    "Have a good time......all the time"
    Ian Mac

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    format the cell with a custom format.
    i.e. 00000

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com