on 2025 Feb 18 7:42 PM
I am using Basic Syntax.
The following simple formula:
formula = "My Number: " & Round(1234.56,0)
yields:
My Number: 1,235.00
The Round function is rounding to zero decimals but also auto-formatting the result to add a comma and display two decimal places.
I tried:
formula = "My Number: " & Format(Round(1234.56,0), "#,##0")
but it doesn't look like Basic Syntax supports the Format function.
Request clarification before answering.
The equivalent function in Crystal is Cstr() or ToText().
The online help provides excellent details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.