+ Reply to Thread
Results 1 to 4 of 4

How to get custom number format to save as text

  1. #1
    Registered User
    Join Date
    06-05-2023
    Location
    Boston, Massachusetts
    MS-Off Ver
    365
    Posts
    2

    Question How to get custom number format to save as text

    Hi, I'm having some trouble with storing phone numbers. I have a bunch of phone numbers I am keeping a record of, with the purpose of uploading them, formatted, to another site. I have used a custom number format to change this:
    1234567890
    Into this:
    +1 (123) 456-7890
    While this looks good in Excel, it does not transfer to the site very well. I figured out that to transfer properly, the phone number must be stored as text (and not a custom number format). Is there any way to capture the "+1 (123) 456-7890" part of it and turn it into text? I have over 4,000 phone numbers, so writing the format out by hand is not possible.

    Thank you!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How to get custom number format to save as text

    Use the TEXT() function: =TEXT(10digitnumber,numberformatcode) https://support.microsoft.com/en-us/...8-93d29371225c
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: How to get custom number format to save as text

    Just thinking out loud here (might be a much more obvious answer), but could you add your Custom Number format into a TEXT function and use that as a new field to upload? If that also doesn't work, you could join a null value to those results and create a third new field to try to upload.

  4. #4
    Registered User
    Join Date
    06-05-2023
    Location
    Boston, Massachusetts
    MS-Off Ver
    365
    Posts
    2

    Re: How to get custom number format to save as text

    Thank you both! The TEXT option worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Text function with custom number format
    By wally_j in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-16-2016, 03:12 AM
  2. Excel 2007 : Help to custom format number with text
    By scarames in forum Excel General
    Replies: 2
    Last Post: 03-25-2011, 09:31 AM
  3. Taking a custom number format to text?
    By jeanchile in forum Excel General
    Replies: 1
    Last Post: 03-04-2011, 09:06 PM
  4. Custom number format with text
    By karstens in forum Excel General
    Replies: 15
    Last Post: 01-18-2011, 12:29 PM
  5. [SOLVED] custom number and random text format
    By CAD Teacher in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 07:00 AM
  6. [SOLVED] Custom Number Format Text
    By Frank & Pam Hayes in forum Excel General
    Replies: 3
    Last Post: 12-03-2005, 01:40 PM
  7. [SOLVED] change custom format number to text
    By joey in forum Excel General
    Replies: 3
    Last Post: 09-20-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1