Search code examples
excelbarcodebarcode-scannerexcel-formulaexcel-2010

Trying to set a date field to barcode

So I am attempting to add a barcode on a spreadsheet that i am using. the problem is when i try and convert the date field, it comes out as a excel datetime type. 

="*"&A5&"*"

A5 is my date field, and this is what the barcode looks like before i switch it to the font.

 *40763*

does anyone have any ideas on how i can make that so I can barcode the date field?

I'm using Excel 2010

Solution

  • For day/month/year:

    ="*" & DAY(A5) & "/" & MONTH(A5) & "/" & YEAR(A5) & "*"