ExcelBanter - Product ID

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Product ID (https://www.excelbanter.com/excel-discussion-misc-queries/192666-product-id.html)

EJ Jacques[_2_]

Product ID

I have Inventory and I want to create up to 7 digit sku or product ID in
excel. Please help me.

David Biddulph[_2_]

Product ID

=TEXT(RANDBETWEEN(0,9999999),"0000000")
--
David Biddulph

"EJ Jacques" wrote in message
...
I have Inventory and I want to create up to 7 digit sku or product ID in
excel. Please help me.

All times are GMT +1. The time now is 11:28 AM.