| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Create Excel macro for barcode output | Excel Discussion (Misc queries) | |||
| How to get blinking Fonts in Excel | Excel Worksheet Functions | |||
| Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! | Charts and Charting in Excel | |||
| Set up barcode column in Excel | Excel Worksheet Functions | |||
Hybrid Mode
