Difference between revisions of "Documentation/How Tos/Calc: CONCATENATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 65: | Line 65: | ||
: returns <tt>'''Print Date: Thursday, 1 January 2009'''</tt> (assuming today's date was Jan 1, 2009). This example serves to demonstrate that you can combine functions in quite complex ways. This example is made up of the date function <tt>'''TODAY()'''</tt> which returns the current date as a number (NOTE: Jan 1, 2009 is represented as 39814) and the text function <tt>'''TEXT()'''</tt> which allows you to format the numeric representation of the date in a [useful] textual format. | : returns <tt>'''Print Date: Thursday, 1 January 2009'''</tt> (assuming today's date was Jan 1, 2009). This example serves to demonstrate that you can combine functions in quite complex ways. This example is made up of the date function <tt>'''TODAY()'''</tt> which returns the current date as a number (NOTE: Jan 1, 2009 is represented as 39814) and the text function <tt>'''TEXT()'''</tt> which allows you to format the numeric representation of the date in a [useful] textual format. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: REPT function|REPT]] | * [[Documentation/How_Tos/Calc: REPT function|REPT]] | ||
Revision as of 07:23, 17 July 2018
CALC FUNCTIONS