| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenate a date
I need to concatenate a date with a text value without the date being turned
into a serial number.....EX: if 8/26/2003 is in A1 and "John Doe" is in A2, when =concatenate(a1,a2), I get '37828John Doe" but what I need is 8/26/2003John Doe I am doing this in code, by the way and it is being reflected in my worksheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| Concatenate a date and name | Excel Worksheet Functions | |||
| concatenate a date and a # ID | Excel Worksheet Functions | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Date CONCATENATE | Excel Worksheet Functions | |||
Threaded Mode
