Custodio,

A formula approach can be used, but you must never insert or delete an item,
sort the table, etc. The result will be to renumber your items. A macro
can assign the next available number, which would be permanently put into
the sheet. If you're willing to use a macro, we'll write you one. We'd
need to know if deletions are allowed from the table.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Custodio Bernardes" <Custodio wrote in
message ...
I would like to give a number to every item I write in every row in excel
automatically in order not to repeat it, in every row I display name and
related specs of each item I sell, example
101 printer
102 scanner
103 camera
104 scanner
105 printer
I'm trying to give each item I sell a personal number to which we may
refer
in the future, we and the customer who bought it, thanks for the help