| 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 |
| 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 | |||
Threaded Mode
