[RESOLVED] Formatting Number of decimal places in a formula
Hi, I have a formula that contains a numerical field. I need to have this in a formula and can not just place the field and i was wondering if there was a way to set the number of decimal places to be displayed in the formula. I know if i just put it on the form I can format it, however is there a way to do this with like a Format() or something. Any help would be appreciated.
Re: Formatting Number of decimal places in a formula
The formula could return a string with the ToText function
ToText(Numeric Field, "#,###.##")
Re: Formatting Number of decimal places in a formula
Thank you, I actually got it to work with
cStr(Field,4)