开发者

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 开发者_StackOverflow中文版


For day/month/year:

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜