So for this example, you would need to use the formula –īonus comment about displaying (or barcoding) dates: The way get the date format into the barcode is to use the TEXT function to show the date in the format you want. 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 kommentar(er)
