Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pattern Formation for Phone Numbers
- Thread starter cbochner
- Start date
Chaim,
Assuming Report Studio, you can play with the number format attributes (for example, Use Thousands Separator=Yes, separator='-', group size 4 and secondary group size 3 will yield the format NNN-NNN-NNNN), but I think you will be better off converting to text and substringing/concatenating as suggested in another forum.
Steve
Assuming Report Studio, you can play with the number format attributes (for example, Use Thousands Separator=Yes, separator='-', group size 4 and secondary group size 3 will yield the format NNN-NNN-NNNN), but I think you will be better off converting to text and substringing/concatenating as suggested in another forum.
Steve
- Status
Similar threads
