Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

i need a formula that adds 1 number to next line in Excel Ex. (name/07/0001 to name/07/0002) going down the pg

I want it to look like this in excel



I would like to be able to put the number in the first line and it total up the rest automaticaly from that. Thanks for any help

2 Answers

  • 1 decade ago
    Favorite Answer

    If I'm not misunderstood with what you need, try to do this. First, format the character i.e. "Name/07/0001" (without the apostophe)(into General), Secondly, go to the right hand corner of the cell that contains "Name/07/0001" until the cursor changed into a small black Plus sign, left click the mouse, hold and drag down the cell. When you do, you will see that everytime you scroll down the cells, the numbers will change from 0001 to 0002, ...03 and so on.

    Hope that's help.

    Source(s): experience
  • 1 decade ago

    from what i know, excel already has this built-in feature. you just need to type in, for example, Name/07/0001 and then point your mouse pointer on the lower right corner of the cell & drag it down till it fills up all the cells you need to fill, incrementing each cell by 1. of course, this is if the cell contain pure numbers. don't know if your setup would work. try it anyway. hope somebody figures out a more scientific answer.

Still have questions? Get your answers by asking now.