| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you write format results of a function within a function?
Hi - I would like the following "Todays date is" & today() to be displayed as
Todays date is 6/13/2007. the today() resolves to the system number. how can I write the format in the concatenate function? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you write format results of a function within a function?
Try this
=A1&" "&TEXT(B1,"dd-mm-yyyy") Text in a1 and date in B1 Mike "sangee" wrote: Hi - I would like the following "Todays date is" & today() to be displayed as Todays date is 6/13/2007. the today() resolves to the system number. how can I write the format in the concatenate function? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you write format results of a function within a function?
="Today date is "&TEXT(TODAY(),"m/d/yyyy")
"sangee" wrote: Hi - I would like the following "Todays date is" & today() to be displayed as Todays date is 6/13/2007. the today() resolves to the system number. how can I write the format in the concatenate function? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you write format results of a function within a function?
Thanks Mike H and Teethless Mama. Right after this post I searched again and
good old google came to my rescue as well "sangee" wrote: Hi - I would like the following "Todays date is" & today() to be displayed as Todays date is 6/13/2007. the today() resolves to the system number. how can I write the format in the concatenate function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to write this function? | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Using function results as parameters in another function | Excel Worksheet Functions | |||
| is there a way to write this function? | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
Linear Mode
