Full Version:
Convet String Of Numbers To Phone Number
UtterAccess Discussion Forums
>
Microsoft® Access
>
Access Queries
carton
Dec 8 2010, 05:31 PM
How can I convert this phone number:
555123444
To the standard phone number format like this:
555-123-4444
Thanks
Alan_G
Dec 8 2010, 05:34 PM
Hi
Try
CODE
Format("555123444","000-00-0000")
carton
Dec 9 2010, 02:27 PM
Perfect!
Thanks Alan
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here
.