Full Version: Convet String Of Numbers To Phone Number
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
carton
How can I convert this phone number:

555123444

To the standard phone number format like this:

555-123-4444

Thanks
Alan_G
Hi

Try

CODE
Format("555123444","000-00-0000")
carton
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.