altosax
asked on
Crystal Reports formatting phone number
I have the following formula to format a phone number:
Picture(ToText({TABLE.FIEL D}), "(xxx) xxx-xxxx")
But the result contains 2 decimal places, such as (555) 123-4567.00
Why is the .00 on there when I am converting it to text? I have tried:
Picture(ToText(Round({TABL E.FIELD},0 )), "(xxx) xxx-xxxx")
But I still get the .00
Picture(ToText({TABLE.FIEL
But the result contains 2 decimal places, such as (555) 123-4567.00
Why is the .00 on there when I am converting it to text? I have tried:
Picture(ToText(Round({TABL
But I still get the .00
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try
Picture(ToText({TABLE.FIEL
That says 0 deicmal places and no thousands separator
You could also use
Picture(ToText({TABLE.FIEL
mlmcc