| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with DateValue and doing Fill doesn't work, need help | Excel Worksheet Functions | |||
| Formula with DateValue and doing Fill doesn't work, need help | Excel Worksheet Functions | |||
| Something other than DATEVALUE | Excel Worksheet Functions | |||
| HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(, | Excel Worksheet Functions | |||
| datevalue | Excel Worksheet Functions | |||
Linear Mode
