It would be useful to have a format function for converting values to text that worked in a similar way to the TEXT function in Excel.
The Function would be FORMAT(Value,"How to Format","Alignment")
e.g Value is 1000.0002 and when converted to text the decimals should not be displayed and left-align the result
FORMAT(Value,"#,##0","L") = 1,000
eg Value is 0.10234 and when converted to text it should be displayed as a % with 1 decimal place and right-align the result
FORMAT(value,"0.0%,"R") = 10.2%
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.