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 IamaSherpa 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
Nov 17, 2000
20
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

JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
241
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
430
hilfy
hilfy
Bloke152
  • Locked
  • Question
Conditional number formatting in Excel export
Replies
3
Views
140
SkipVought
S
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
146
hilfy
hilfy
VHDN
  • Locked
  • Question
Reset page number
Replies
2
Views
162
VHDN
VHDN

Part and Inventory Search

Sponsor

Back
Top