I'm creating a barcode that containes several fields from a worksheet.
One of the fields needs the be the date it is cell L4 and L4 contains
=today() to get the date. When the date is pulled from here it comes in
as 38846. How do I get it to display 050906?
This is the formula creating the barcode
=CONCATENATE("*",UPPER(A4),B31,H8,L4,UPPER(H1),"*" )
--
nicole0904
------------------------------------------------------------------------
nicole0904's Profile:
http://www.excelforum.com/member.php...o&userid=31774
View this thread:
http://www.excelforum.com/showthread...hreadid=540425