| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking a text with a date and can't remember the format
I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3.
When I input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs something like m/d/yy with the A2 but can;t remember what format it needs. Thanks, Laura |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a text with a date and can't remember the format
In A3: =A1&TEXT(A2,"mm/dd/yy")
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "lauras03" wrote: I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3. When I input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs something like m/d/yy with the A2 but can;t remember what format it needs. Thanks, Laura |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a text with a date and can't remember the format
Well, this works for me, but seems there should be a better way...
=A1 & TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2))," m/d/yy") P.S. Happy Birthday, Sam. Welcome to the world?? Or is there not really a Sam? <g "lauras03" wrote: I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3. When I input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs something like m/d/yy with the A2 but can;t remember what format it needs. Thanks, Laura |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a text with a date and can't remember the format
In the earlier, I presumed A2 contained a real date (the birth date)
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a text with a date and can't remember the format
Yes, you're right, Jerry. There is a better way. :-)
=A1 & TEXT(A2," m/d/yy") -- David Biddulph "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Well, this works for me, but seems there should be a better way... =A1 & TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2))," m/d/yy") P.S. Happy Birthday, Sam. Welcome to the world?? Or is there not really a Sam? <g "lauras03" wrote: I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3. When I input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs something like m/d/yy with the A2 but can;t remember what format it needs. Thanks, Laura |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
linking a text with a date and can't remember the format
Dadgummit! I tried TEXT() early on and couldn't get it to do it. Must not
have been holding my tongue right. Thanks! So many worksheet functions, so few little gray cells... "David Biddulph" wrote: Yes, you're right, Jerry. There is a better way. :-) =A1 & TEXT(A2," m/d/yy") -- David Biddulph "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Well, this works for me, but seems there should be a better way... =A1 & TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2))," m/d/yy") P.S. Happy Birthday, Sam. Welcome to the world?? Or is there not really a Sam? <g "lauras03" wrote: I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3. When I input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs something like m/d/yy with the A2 but can;t remember what format it needs. Thanks, Laura |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| Text to date format | Excel Discussion (Misc queries) | |||
| text date to date format | Excel Discussion (Misc queries) | |||
| Date to text format | Excel Discussion (Misc queries) | |||
Linear Mode
