« I'm Back! | Main | Splitting a string into characters »
August 17, 2005
Basic functions: TEXT
At first glance, the TEXT function may not sound very useful. Here are a few simple applications.In the top example, without the TEXT function, the total is not formatted correctlt (as a currency). However, the TEXT function allows us to apply the correct format to the number component of the string.
In the second example, we see how the TEXT function allows us to reformat existing data - such as dates.
Posted by Dave at August 17, 2005 10:06 PM