adding a zero
Results 1 to 3 of 3

Thread: adding a zero
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default adding a zero

    Hi all,

    my co-worker sent me a file that was originally a csv. I don't have that file, she sent it to me in excel but in the excel for some reason dropped the 0 in the columns if that was the first character in the cell.

    Is there anyway that I can add a zero to the beginning of each cell, without having to manually enter them? This sheet is over 4,000 rows.

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    49,997
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    11 Thread(s)

    Default Re: adding a zero

    How many columns do you have, and now many need correcting?
    How can you tell which values need a zero added to them (should the all be a certain length)?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Apr 2015
    Posts
    182
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: adding a zero

    If the field is zip code, then format the column using Special --> Zip OR Zip Plus 4.

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
  •