Simple Concatenate

[Kreiss]

I'm trying to concatenate.......

="As of " & Today().

However its converting today's date to excel date format.

exp.How do i get it to display..... As of 10/03/2003

Thanks in advance,
Kacy

 

[Harlan Grove]

I'm trying to concatenate.......

="As of " & Today().

However its converting today's date to excel date format.

exp.How do i get it to display..... As of 10/03/2003

="As of "&TEXT(TODAY(),"mm/dd/yyyy")

 

[J.E. McGimpsey]

one way:

="As of " & TEXT(TODAY(), "mm/dd/yyyy")

 

[Bernie Deitrick]

Kacy,

="As of " & Text(Today(), "mm/dd/yyyy")

HTH,
Bernie

 

[Kreiss]

Thanks, Works Great!!

-----Original Message-----
Kacy,

="As of " & Text(Today(), "mm/dd/yyyy")

HTH,
Bernie





.