Results 1 to 4 of 4

Thread: Keep leading zeroes after Text to Columns

  1. #1
    Board Regular
    Join Date
    Jan 2013
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Keep leading zeroes after Text to Columns

    I have a comma-separated .txt file of employee bank account information. When I open in Excel and run Text to Columns, it removes the leading zeroes from bank account numbers that have them. Even in the formula bar if I click on one of the cells that I know was an account number with a leading zero, the zero is gone (but it was there in the .txt file before I separated it). I also have the file in an Excel CSV where it's already separated, but still don't have the leading zero.

    I have tried both the "general" and "text" column data formats in Step 3 of the wizard but both give the same result.

    Help?

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Keep leading zeroes after Text to Columns

    Are you importing the data via the data tab?
    If so when you get the import wizard, select the column with the account numbers & then select text
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Jan 2013
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Keep leading zeroes after Text to Columns

    Thanks, I didn't notice that the column with the account numbers wasn't selected as the one I was formatting to text! I thought it would change the whole thing. This worked perfectly, thank you so much!!

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Keep leading zeroes after Text to Columns

    Glad to help & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

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
  •