| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to add dates. | Excel Worksheet Functions | |||
| US dates to UK?? | Excel Worksheet Functions | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| Problem with date base units for x axis | Charts and Charting in Excel | |||
Hybrid Mode
