ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do i set up a data base in excel for code 128 (https://www.excelbanter.com/excel-discussion-misc-queries/93089-how-do-i-set-up-data-base-excel-code-128-a.html)

charlieking4747

How do i set up a data base in excel for code 128
 
I want to set up a cosecutive number database for generating code 128 bar
codes. The numbers need to read 00 123456 000 next 00 123457 000 incrementing
by one each time. Is this possible?

kassie

How do i set up a data base in excel for code 128
 
With your first number - 00 123456 000 in A1, try the following in A2, and
copy down as far as required.
="00 "&MID(A1,4,6)+1& " 000"

"charlieking4747" wrote:

I want to set up a cosecutive number database for generating code 128 bar
codes. The numbers need to read 00 123456 000 next 00 123457 000 incrementing
by one each time. Is this possible?



All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com