Dates Problem

[nicole0904]

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 contain
=today() to get the date. When the date is pulled from here it comes i
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),"*"

 

[ianonline]

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

 

[nicole0904]

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.

 

[Peo Sjoblom]

Use


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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[David Biddulph]

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

 

[nicole0904]

Awesome! Thanks!