Dates Problem
 

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

Dates Problem
 

I'm surprised you know quite an advanced formula like that (which I
don't understand) but are stuck with this! Just right click on the cell
with "38846" and select Format Cells. Select "Date" from the list and
choose the date format of your choice.

Ian


--
ianonline
------------------------------------------------------------------------
ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279
View this thread: http://www.excelforum.com/showthread...hreadid=540425

Dates Problem
 

I've tried formatting it as a date, it doesn't change though. I'm
assuming it's not changing because of the other stuff in there.


--
nicole0904
------------------------------------------------------------------------
nicole0904's Profile: http://www.excelforum.com/member.php...o&userid=31774
View this thread: http://www.excelforum.com/showthread...hreadid=540425

Dates Problem
 

Use


=CONCATENATE("*",UPPER(A4),B31,H8,TEXT(L4,"mmddyy" ),UPPER(H1),"*")

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"nicole0904" wrote
in message ...

I've tried formatting it as a date, it doesn't change though. I'm
assuming it's not changing because of the other stuff in there.


--
nicole0904
------------------------------------------------------------------------
nicole0904's Profile:
http://www.excelforum.com/member.php...o&userid=31774
View this thread: http://www.excelforum.com/showthread...hreadid=540425

Dates Problem
 

"nicole0904" wrote
in message ...

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),"*" )

Try =CONCATENATE("*",UPPER(A4),B31,H8,TEXT(L4,"MMDDYY" ),UPPER(H1),"*")
--
David Biddulph

Dates Problem
 

Awesome! Thanks!


--
nicole0904
------------------------------------------------------------------------
nicole0904's Profile: http://www.excelforum.com/member.php...o&userid=31774
View this thread: http://www.excelforum.com/showthread...hreadid=540425