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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number to Phone Number

Status
Not open for further replies.
samimichaels

samimichaels

IS-IT--Management
Joined
Nov 17, 2000
Messages
20
Location
US
I have a field that is a phone number is ########## format that I would like to change to (###) ###-#### format. And I can't remember how to do this.

 
Sort by date Sort by votes
using the formula editor :

"(" & left({phonefield},3) & ") " & mid({phonefield},4,3) & "-" & right({phonefield},4)



HTH
Fred
 
Upvote 0 Downvote
alternatively use the Picture command, which allows u to put a mask over a string to format as u require

ie Picture ({fieldname},"(xxx) xxx-xxxx")

should do the trick

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
424
DjangMan
DjangMan
JustMe24
  • Locked
  • Question Question
How to select from 2 rows in a table
Replies
1
Views
717
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy
Bloke152
  • Locked
  • Question Question
Conditional number formatting in Excel export
Replies
3
Views
468
SkipVought
S
PeteyN.O
  • Locked
  • Question Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
434
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top