cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Does Basic Syntax support the Format function?

RaymondAC
Discoverer
0 Likes
333

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.

Accepted Solutions (1)

Accepted Solutions (1)

ido_millet
Active Contributor
0 Likes

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

The online help provides excellent details.

Answers (1)

Answers (1)

DonWilliams
Active Contributor
0 Likes

Once in CR Designer hit the F1 key to open the help file and search for Round:

Basic and Crystal syntax.

Overloads

  • Round (x)

  • Round (x, #places)