cancel
Showing results for 
Search instead for 
Did you mean: 

Does Basic Syntax support the Format function?

RaymondAC
Newcomer
0 Kudos
100

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.

View Entire Topic
ido_millet
Active Contributor
0 Kudos

The equivalent function in Crystal is Cstr() or ToText().

The online help provides excellent details.