{"id":8842,"date":"2022-01-26T17:09:16","date_gmt":"2022-01-26T17:09:16","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=8842"},"modified":"2024-03-27T23:47:03","modified_gmt":"2024-03-27T23:47:03","slug":"fix-numbers-stored-as-text","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/","title":{"rendered":"Fix Numbers Stored as Text in Excel"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-e9a6303e-f89a-4624-97ea-8ae7ae781dd2\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Fix-Numbers-Stored-as-Text-in-Excel.xlsx\">Fix-Numbers-Stored-as-Text-in-Excel<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/01\/Fix-Numbers-Stored-as-Text-in-Excel.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-e9a6303e-f89a-4624-97ea-8ae7ae781dd2\">Download File<\/a><\/div>\n\n\n\n<p>As already noted, a lot of problems that people come across in Excel are related to formatting. One of the most common issues is when Excel keeps your numbers stored as text, or when you download data and it simply will not convert to numbers. This tends to be a large issue, as you cannot type formulas with this format.<\/p>\n\n\n\n<p>In the example below, we will show how to resolve this issue.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fix Numbers Stored as Text by Converting Range<\/h2>\n\n\n\n<p>If we happen to copy some data in our sheet, or we have our numbers formatted as text for any other reason, Excel will usually tell us so by displaying an error message in a triangle. These cells will also have a little green triangle in a top left corner of a cell, as shown in our example below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"189\" height=\"347\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png\" alt=\"A picture containing chart\n\nDescription automatically generated\" class=\"wp-image-8843\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png 189w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica-163x300.png 163w\" sizes=\"(max-width: 189px) 100vw, 189px\" \/><\/figure>\n\n\n\n<p>When we hover over the triangle, we will see a couple of options that Excel provides us with:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"347\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-1.png\" alt=\"Graphical user interface, application, table\n\nDescription automatically generated\" class=\"wp-image-8844\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-1.png 346w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-1-300x300.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-1-150x150.png 150w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/figure>\n\n\n\n<p>There are many options, such as <strong>Ignore Error, Edit in Formula Bar<\/strong>, etc. but to change the formatting of the first cell, we would have to click simply on the <strong>Convert to Number<\/strong> option. However, that would only apply the changes to one cell. This would make the process of changing the entire range pretty painful.<\/p>\n\n\n\n<p>What we need to do to change the entire scope is to select it, and then click on this option on any triangle at our disposal:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"357\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-9.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-8845\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-9.png 346w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-9-291x300.png 291w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/figure>\n\n\n\n<p>Once we click on this option, we should have our cells formatted to numbers:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"145\" height=\"340\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/table-description-automatically-generated-with-me-2.png\" alt=\"Table\n\nDescription automatically generated with medium confidence\" class=\"wp-image-8846\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/table-description-automatically-generated-with-me-2.png 145w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/table-description-automatically-generated-with-me-2-128x300.png 128w\" sizes=\"(max-width: 145px) 100vw, 145px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Fix Numbers Stored as Text with Multiplier<\/h2>\n\n\n\n<p>Sometimes, however, we will not have the triangles (nor the green one nor the yellow one) that could be seen in the first example as an indicator that we have an error.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"131\" height=\"346\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/table-description-automatically-generated-with-me-3.png\" alt=\"Table\n\nDescription automatically generated with medium confidence\" class=\"wp-image-8847\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/table-description-automatically-generated-with-me-3.png 131w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/table-description-automatically-generated-with-me-3-114x300.png 114w\" sizes=\"(max-width: 131px) 100vw, 131px\" \/><\/figure>\n\n\n\n<p>If we would go on and click any of these numbers, we could easily inspect that they are formatted as Text. What we need to do now is input <strong>number 1<\/strong> in any blank cell (make sure that that cell is not formatted as text!). We will store ours in <strong>cell H2<\/strong> and then right-click on it, and copy this cell. Once we do, we will select the entire range that we want to format, right-click and then go to <strong>Paste Special option<\/strong> as in the picture below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"431\" height=\"463\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-10.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-8848\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-10.png 431w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-10-279x300.png 279w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/figure>\n\n\n\n<p>On the window that appears, we will choose the <strong>Multiply<\/strong> under <strong>Operations<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"332\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-11.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-8849\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-11.png 400w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-11-300x249.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/figure>\n\n\n\n<p>We will click <strong>OK <\/strong>and our range will be formatted:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"132\" height=\"338\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-screenshot-of-a-phone-description-automatically.png\" alt=\"A screenshot of a phone\n\nDescription automatically generated with medium confidence\" class=\"wp-image-8850\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-screenshot-of-a-phone-description-automatically.png 132w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-screenshot-of-a-phone-description-automatically-117x300.png 117w\" sizes=\"(max-width: 132px) 100vw, 132px\" \/><\/figure>\n\n\n\n<p>When we use a multiplicator, that makes the contents of our cells transform into their numerical values.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fix Numbers Stored as Text with Text to Columns<\/h2>\n\n\n\n<p>The options that have been presented above are good and practical when dealing with smaller ranges. The problem that might happen with dealing with big data is that Excel can take longer to process, and it will, in some instances, crash. Luckily, there is a simple solution to this problem as well.<\/p>\n\n\n\n<p>Suppose that we have the following range of numbers:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"519\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-2.png\" alt=\"Graphical user interface, application, table\n\nDescription automatically generated\" class=\"wp-image-8851\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-2.png 494w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-table-desc-2-286x300.png 286w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/figure>\n\n\n\n<p>You will notice that our range is formatted as <strong>General, <\/strong>not<strong> Text <\/strong>but we still somehow have the same issue.<\/p>\n\n\n\n<p>To resolve the issue, all you need to do is select the range, then go to <strong>Data &gt;&gt; Text to Columns:<\/strong> <img loading=\"lazy\" decoding=\"async\" width=\"1071\" height=\"129\" class=\"wp-image-8852\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/word-image-2.png\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/word-image-2.png 1071w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/word-image-2-300x36.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/word-image-2-1024x123.png 1024w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/word-image-2-768x93.png 768w\" sizes=\"(max-width: 1071px) 100vw, 1071px\" \/><\/p>\n\n\n\n<p>When we click on it, we will choose <strong>Next <\/strong>for the first two options, and then simply click <strong>Finish<\/strong>. We do not need to change anything in our steps.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"506\" height=\"416\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-12.png\" alt=\"Graphical user interface, application\n\nDescription automatically generated\" class=\"wp-image-8853\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-12.png 506w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/graphical-user-interface-application-description-12-300x247.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/figure>\n\n\n\n<p>The result is as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"133\" height=\"351\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-screenshot-of-a-phone-description-automatically-1.png\" alt=\"A screenshot of a phone\n\nDescription automatically generated with medium confidence\" class=\"wp-image-8854\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-screenshot-of-a-phone-description-automatically-1.png 133w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-screenshot-of-a-phone-description-automatically-1-114x300.png 114w\" sizes=\"(max-width: 133px) 100vw, 133px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>As already noted, a lot of problems that people come across in Excel are related to formatting. One of the most common issues&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fix Numbers Stored as Text in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to fix numbers stored as text in Excel with this easy-to-follow guide. Download the file and follow along step by step!\" \/>\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\/fix-numbers-stored-as-text\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fix Numbers Stored as Text in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to fix numbers stored as text in Excel with this easy-to-follow guide. Download the file and follow along step by step!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-26T17:09:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-27T23:47:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Fix Numbers Stored as Text in Excel\",\"datePublished\":\"2022-01-26T17:09:16+00:00\",\"dateModified\":\"2024-03-27T23:47:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/\"},\"wordCount\":574,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/\",\"name\":\"Fix Numbers Stored as Text in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png\",\"datePublished\":\"2022-01-26T17:09:16+00:00\",\"dateModified\":\"2024-03-27T23:47:03+00:00\",\"description\":\"Learn how to fix numbers stored as text in Excel with this easy-to-follow guide. Download the file and follow along step by step!\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fix Numbers Stored as 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\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fix Numbers Stored as Text in Excel","description":"Learn how to fix numbers stored as text in Excel with this easy-to-follow guide. Download the file and follow along step by step!","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\/fix-numbers-stored-as-text\/","og_locale":"en_US","og_type":"article","og_title":"Fix Numbers Stored as Text in Excel","og_description":"Learn how to fix numbers stored as text in Excel with this easy-to-follow guide. Download the file and follow along step by step!","og_url":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/","article_published_time":"2022-01-26T17:09:16+00:00","article_modified_time":"2024-03-27T23:47:03+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Fix Numbers Stored as Text in Excel","datePublished":"2022-01-26T17:09:16+00:00","dateModified":"2024-03-27T23:47:03+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/"},"wordCount":574,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/","url":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/","name":"Fix Numbers Stored as Text in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png","datePublished":"2022-01-26T17:09:16+00:00","dateModified":"2024-03-27T23:47:03+00:00","description":"Learn how to fix numbers stored as text in Excel with this easy-to-follow guide. Download the file and follow along step by step!","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/01\/a-picture-containing-chart-description-automatica.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/fix-numbers-stored-as-text\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Fix Numbers Stored as 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\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8842"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=8842"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8842\/revisions"}],"predecessor-version":[{"id":17327,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/8842\/revisions\/17327"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=8842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=8842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=8842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}