Help with the CONCATENATE formula
This worked. Thanks
--
tech1NJ
"bapeltzer" wrote:
The concatenate will pull in the value but not the format. You can dictate
the format using the text function:
="Your service will expire on " & text(Sheet2!D32,"Mmmm d, yyyy") etc
"tech1NJ" wrote:
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
|