Use the following formula
=CONCATENATE(A1," ",TEXT(A2,"mm-dd-"))
where A1 = Today is and A2 = date
Rg
On Mon, Jul 27, 2009 at 8:38 PM, Radhe Sham L wrote:
> Hi Group
>
> This is a query regarding the date format retention in concatenate
>
> What happens is while concatenating some text wit
You have to keep in mind that what YOU see as a date
is actually a number FORMATTED as a date.
the Display format of "Date" is much the same as "blue", or "bold".
so.. if you're concatenating strings together and wanted to keep the "blue/bold"
FORMATTING in the combined string... I suppose it COUL
Dear Radhe Sham,
Use
Text(Date,"dd-mmm-yy")
while concatenating
e.g. "Today is "&Text(Today(),"dd-mmm-yy") will give Today is 27-Jul-09 as
result.
Please let me know if it helps.
Regards,
Andy
On Mon, Jul 27, 2009 at 10:08 PM, Radhe Sham L wrote:
> Hi Group
>
> This is a query regarding the
