| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with the CONCATENATE formula
I would like to CONCATENATE the following phrases on Sheet1!A19 with dates
from Sheet2!D32 and Sheet2!D33 but am having some problems. Please help. I would like to see the following in Sheet1!A19: Your service will expire on April 19, 2009. However, your last preventive maintanence with revalidation was on March 1, 2008. Problem being displayed is the following: Your service will expire on 39922 and your last preventive maintanence with revalidation was on 39508. The dates on Sheet2!D32 and Sheet2!D33 are formated for a Date with the following format - April 19, 2009. -- tech1NJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate Formula doesn't do its job... | Excel Discussion (Misc queries) | |||
| CONCATENATE Formula | Excel Discussion (Misc queries) | |||
| Need help with concatenate formula | Excel Worksheet Functions | |||
| Concatenate in a formula | Excel Worksheet Functions | |||
| Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
Threaded Mode
