{"id":12017,"date":"2022-11-03T09:16:20","date_gmt":"2022-11-03T09:16:20","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=12017"},"modified":"2024-03-26T11:06:24","modified_gmt":"2024-03-26T11:06:24","slug":"convert-long-numbers-to-text","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/","title":{"rendered":"Convert Long Numbers to Text in Excel"},"content":{"rendered":"\n
Convert-Long-Numbers-to-Text-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\n

When you type a number that has more than 15 digits in a cell in Excel, Excel converts any digit beyond the fifteenth position to a zero.<\/p>\n\n\n\n

This can render invalid, for example, a credit card ID number that contains more than 15 digits. You can avoid this problem by converting long numbers to text. This tutorial shows two methods of how to convert long numbers to text in<\/a> Excel.<\/p>\n\n\n\n

Method 1: Precede the Numbers with Single Quotation Marks<\/h2>\n\n\n\n

This method is suitable for small datasets.<\/p>\n\n\n\n

Suppose we have the following information about clients\u2019 credit card ID numbers in a Word table:<\/p>\n\n\n\n

\"Table\n\nDescription<\/figure>\n\n\n\n

Each client\u2019s credit card ID number is seventeen digits long. We are required to enter the credit card ID numbers in the dataset below:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We use the following steps:<\/p>\n\n\n\n

    \n
  1. Select cell B2.<\/li>\n\n\n\n
  2. Type in an apostrophe followed by the credit card ID number of the first client.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    All seventeen digits are displayed in cell B2.<\/p>\n\n\n\n

    Note:<\/strong> Look in the formula bar to see the apostrophe that precedes the number.<\/p>\n\n\n\n

      \n
    1. Enter the credit card ID numbers for the other two clients in cells B3 and B4 in the same way you did for the first client.<\/li>\n<\/ol>\n\n\n\n
      \"Table\n\nDescription<\/figure>\n\n\n\n

      Get Rid of the Error Indicators<\/h3>\n\n\n\n

      If you select any of the cells that contain credit card ID numbers, an error indicator appears next to it.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      To get rid of the error indicator, click on it and choose Ignore Error<\/strong> on the shortcut menu that appears.<\/p>\n\n\n\n

      \"Graphical<\/figure>\n\n\n\n

      Get rid of the error indicators in cells B3 and B3 in the same way. The dataset looks clean without the error indicators.<\/p>\n\n\n\n

      \"Table\n\nDescription<\/figure>\n\n\n\n

      Method 2: Apply The Text Format to The Cells Then Enter The Data<\/h2>\n\n\n\n

      To avoid having to type an apostrophe in every cell before entering the numbers, you can apply the text format to the cells before entering data.<\/p>\n\n\n\n

      Suppose we have the following information about clients\u2019 credit card ID numbers in a Word table:<\/p>\n\n\n\n

      \"Table\n\nDescription<\/figure>\n\n\n\n

      Each client\u2019s credit card ID number is seventeen digits long. We are required to enter the credit card ID numbers in the dataset below:<\/p>\n\n\n\n

      \"Table\n\nDescription<\/figure>\n\n\n\n

      We use the steps below:<\/p>\n\n\n\n

        \n
      1. Select range B2:B4.<\/li>\n<\/ol>\n\n\n\n
        \"Table\n\nDescription<\/figure>\n\n\n\n
          \n
        1. Open the Format Cells<\/strong> dialog box<\/a> using any of the following ways:<\/li>\n<\/ol>\n\n\n\n

          Press Ctrl + 1<\/strong><\/p>\n\n\n\n

          Or<\/strong><\/p>\n\n\n\n

          Right-click the selected range and choose Format Cells<\/strong> on the shortcut menu:<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Or<\/strong><\/p>\n\n\n\n

          Select the Home<\/strong> tab, and click the Number Format<\/strong> dialog box launcher icon in the right bottom corner of the Number<\/strong> group:<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n
            \n
          1. In the Format Cells<\/strong> dialog box that appears, in the Number<\/strong> tab, select Text<\/strong> in the Category<\/strong> list box and click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. Enter the credit card ID numbers in cells B2, B3, and B4.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n

              Note:<\/strong> To get rid of the error indicators in range B2:B4 at one go instead of doing it one at a time, do the steps below:<\/p>\n\n\n\n

                \n
              • Select range B2:B4.<\/li>\n<\/ul>\n\n\n\n
                \"\"<\/figure>\n\n\n\n
                  \n
                • Click the error indicator next to cell B2 and choose Ignore Error<\/strong> on the shortcut menu.<\/li>\n<\/ul>\n\n\n\n
                  \"\"<\/figure>\n\n\n\n

                  All the error indicators are removed from the dataset.<\/p>\n\n\n\n

                  \"\"<\/figure>\n\n\n\n

                  Conclusion<\/h2>\n\n\n\n

                  This tutorial showed two methods of how to convert long numbers to text. In the first method, we first type in an apostrophe before entering the long numbers. In the second method, we first apply a text format to the target cells before entering the long numbers.<\/p>\n","protected":false},"excerpt":{"rendered":"

                  When you type a number that has more than 15 digits in a cell in Excel, Excel converts any digit beyond the fifteenth…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nConvert Long Numbers to Text in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to convert long numbers to text in Excel and avoid rendering invalid numbers. Method 1: precede numbers with apostrophes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Long Numbers to Text in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert long numbers to text in Excel and avoid rendering invalid numbers. Method 1: precede numbers with apostrophes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-03T09:16:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Convert Long Numbers to Text in Excel\",\"datePublished\":\"2022-11-03T09:16:20+00:00\",\"dateModified\":\"2024-03-26T11:06:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\"},\"wordCount\":550,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\",\"name\":\"Convert Long Numbers to Text in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png\",\"datePublished\":\"2022-11-03T09:16:20+00:00\",\"dateModified\":\"2024-03-26T11:06:24+00:00\",\"description\":\"Learn how to convert long numbers to text in Excel and avoid rendering invalid numbers. Method 1: precede numbers with apostrophes.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Long Numbers to Text in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert Long Numbers to Text in Excel","description":"Learn how to convert long numbers to text in Excel and avoid rendering invalid numbers. Method 1: precede numbers with apostrophes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/","og_locale":"en_US","og_type":"article","og_title":"Convert Long Numbers to Text in Excel","og_description":"Learn how to convert long numbers to text in Excel and avoid rendering invalid numbers. Method 1: precede numbers with apostrophes.","og_url":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/","article_published_time":"2022-11-03T09:16:20+00:00","article_modified_time":"2024-03-26T11:06:24+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Convert Long Numbers to Text in Excel","datePublished":"2022-11-03T09:16:20+00:00","dateModified":"2024-03-26T11:06:24+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/"},"wordCount":550,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/","url":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/","name":"Convert Long Numbers to Text in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png","datePublished":"2022-11-03T09:16:20+00:00","dateModified":"2024-03-26T11:06:24+00:00","description":"Learn how to convert long numbers to text in Excel and avoid rendering invalid numbers. Method 1: precede numbers with apostrophes.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/11\/table-description-automatically-generated.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Convert Long Numbers to Text in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12017"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=12017"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12017\/revisions"}],"predecessor-version":[{"id":15403,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/12017\/revisions\/15403"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=12017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=12017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=12017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}