So when you assign a cell a value which you set the font to “FREE 3 of 9″ barcode font (or the extended version), the formula you would have is –įor dates, the above formula results in output like *43466* instead of **. If you don’t do this, the barcode won’t work. When using barcode (at least ‘3 of 9’) you need to start and end it with an asterisk (*) character. If A1 contains your date, either using a formula or merely entered as a date, and you need to choose a suitable format for excel to show that date. You have to be careful which date format you pick for dates when using them in a barcode. I’ve been a bit verbose but hopefully it will explain what I think your question is asking. Just saw your query post from the beginning of the year (by accident than deliberate looking).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |