Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
How to code it in excel? | Excel Worksheet Functions | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |