View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barcodewiz
 
Posts: n/a
Default Zero Suppression in Excel barcode fonts

There is a special shortcut for that in Excel. All you need to do is
prefix each cell with an apostrophe. So, for example, instead of
typing:
000123
....you should type in:
'000123

When creating your barcodes the apostrophe will be ignored, but you
will get the leading zeros.

Alek Szymanski
http://www.barcodewiz.com

PHELM1 wrote:
How do you stop Excel from suppressing the leading zeros in a cell used for a
barcode that is created using a cell that has them?