You cannot re-number the rows.

You can simulate a re-numbering.

In A1 enter =ROW()-1 and drag/copy down.

Why do you have to have the row numbering changed to accommodate your IP
addresses?


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 10:40:00 -0700, Tim wrote:

I want to the rows to start at 0 so I can have the default numbering match
the ip addresses of devices on my network Is this possible?

Ultimately I want the top row to be just headings like " Device, Make/Model,
Serial Number, etc. I just can't have it start at 1 because it takes my
192.168.1.1 address spot. So it doesn't have to be 0 for the first row, I'd
settle for a blank row, but I don't think that's possible. Any help is
appreciated.