ExcelBanter - Excel Bar Code

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

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

- - Excel Bar Code (https://www.excelbanter.com/excel-discussion-misc-queries/200228-excel-bar-code.html)

David

Excel Bar Code

Hi

I am entering bar codes in excel as 0900000901080, I need these to
automatically fill in in sequence and I am having problems with the 0 in
front, can anybody offer a solution?

Regards David

Sheeloo

Excel Bar Code

Format Cell, Choose Custom Format and enter the format as 0000000000000 (I am
assuming you need 13 digit numbers with leading zeroes). This will pad your
numbers with zeroes to give you a 13 digit number

"David" wrote:

Hi

I am entering bar codes in excel as 0900000901080, I need these to
automatically fill in in sequence and I am having problems with the 0 in
front, can anybody offer a solution?

Regards David

gemini

Excel Bar Code

Prefix your number with an apostrophe.

hth!

-- Gemini

"David" wrote:

Hi

I am entering bar codes in excel as 0900000901080, I need these to
automatically fill in in sequence and I am having problems with the 0 in
front, can anybody offer a solution?

Regards David

All times are GMT +1. The time now is 07:00 PM.