Crystal Reports formatting phone number

I have the following formula to format a phone number:

Picture(ToText({TABLE.FIELD}), "(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({TABLE.FIELD},0)), "(xxx) xxx-xxxx")

But I still get the .00
altosaxAsked:
Who is Participating?
 
James0628Connect With a Mentor Commented:
If any of your phone numbers are 7 digits, with no area code, you may want to try to handle that.  mlmcc's second suggestion would put 0's where the area code would be, which may be good enough.  Another option would be the following, which would leave the area code blank if there were only 7 digits.

Picture(ToText({TABLE.FIELD}, "##########"), "(xxx) xxx-xxxx")


 James
0
 
mlmccCommented:
Unless you tell ToText and CStr how to format the number, it uses the system default which is generally 2 decimals

Try

Picture(ToText({TABLE.FIELD},0,""), "(xxx) xxx-xxxx")

That says 0 deicmal places and no thousands separator

You could also use

Picture(ToText({TABLE.FIELD},"0000000000"), "(xxx) xxx-xxxx")

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.