| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate Dates
Hello,
I need help to concatenate a date field. For example, I'd like one of them to say "Posted 1/12/2007". Instead I'm getting "Posted 39094". Thanks in advance for your help. Ellen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate Dates
Try this with date in A1
="Posted " & TEXT(A1,"mm/dd/yyyy") If this post helps click Yes --------------- Jacob Skaria "EllenM" wrote: Hello, I need help to concatenate a date field. For example, I'd like one of them to say "Posted 1/12/2007". Instead I'm getting "Posted 39094". Thanks in advance for your help. Ellen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate Dates
Thanks, Jacob. Code works beautifully!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to CONCATENATE two dates field together | Excel Worksheet Functions | |||
| Concatenate several dates and hide 1/00/00 | Excel Discussion (Misc queries) | |||
| Concatenate Dates | Excel Discussion (Misc queries) | |||
| concatenate with dates | Excel Discussion (Misc queries) | |||
| concatenate dates? | Excel Discussion (Misc queries) | |||
Hybrid Mode
