Text function

[Gary]

I want my fornula to have the Date & the word Cost
Today() & " Cost" returns 38037 Cost
Concatenate(Today()," Cost" returns 38037 Cost
Text(Today(),"Date") & " Cost" returns 20at2004 Cost
Text(Today(),"Text") & " Cost" returns T2004xt Cost Roll

Is there a way to make this work?

 

[Frank Kabel]

Hi
try
=TEXT(TODAY(),"MM-DD-YYYY") & " Cost"

 

[macropod]

Hi Gary,

Try:
=TEXT(TODAY(),"dd-mmm-yyyy") & " Cost"

Cheers