If you are building a form in Excel, is it possible to format a result of a calculation to round it to a set number of decimal places, or to put a currency symbol in front? For example in the 'Tip' example, could you make the result show up as $5.25, rather than 5.24906 ?
Thanks,
Hi Natalie,
This is possible. You'll need to create a calculate type row that rounds
the value using a calculation column like this:
round(${number}, 2)
Then in the label just include an additional currency symbol like so:
$${tip}
Regards,
-Nathan
···
On Tuesday, September 25, 2012 4:32:59 PM UTC-7, Natalie Telck wrote:
>
> If you are building a form in Excel, is it possible to format a result
> of a calculation to round it to a set number of decimal places, or to put a
> currency symbol in front? For example in the ‘Tip’ example, could you make
> the result show up as $5.25, rather than 5.24906 ?
>
> Thanks,
>
>
>
> *Natalie *
>
>
>