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

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Dave" schrieb im Newsbeitrag
...
I am making a formula that uses the concatenate function using regular text
and the today's date.

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

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

--

HTH

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


"Dave" wrote in message
...
I am making a formula that uses the concatenate function using regular
text
and the today's date.

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Bob Phillips" schrieb im Newsbeitrag
...
="abc" & TEXT(TODAY(),"dd mmm yyyy")

--

HTH

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


"Dave" wrote in message
...
I am making a formula that uses the concatenate function using regular
text
and the today's date.

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

Hi Frank,

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

Bob


"Frank Kabel" wrote in message
...
Hi Bob
you're definetely better at guessing this evening :-)
After reading your response even I understood the OP's question <vbg

--
Regards
Frank Kabel
Frankfurt, Germany
"Bob Phillips" schrieb im Newsbeitrag
...
="abc" & TEXT(TODAY(),"dd mmm yyyy")

--

HTH

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


"Dave" wrote in message
...
I am making a formula that uses the concatenate function using regular
text
and the today's date.