![]() You can of course choose whatever date format you wish. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |