I need to change the datevalue to date_text in a formula because .

[Guest]

I am making a formula that uses the concatenate function using regular text
and the today's date.

 

[Frank Kabel]

Hi
not really sure what you're trying to achieven. Maybe give an example of
your data and your expected result

 

[Bob Phillips]

="abc" & TEXT(TODAY(),"dd mmm yyyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob
you're definetely better at guessing this evening
After reading your response even I understood the OP's question <vbg>

 

[Bob Phillips]

Hi Frank,

You know I articulate that badly myself, so it comes as second nature<vbg>

Bob