{"id":1525,"date":"2023-03-14T07:17:06","date_gmt":"2023-03-14T07:17:06","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=1525"},"modified":"2023-11-14T07:57:50","modified_gmt":"2023-11-14T07:57:50","slug":"convert-text-to-number-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel","title":{"rendered":"How to Convert Text to Number in Excel (6 Easy Ways)"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">It is quite a frustrating situation when the numbers are formatted or stored as text in an Excel spreadsheet. Due to this, you\u2019ll be unable to perform various Excel tasks like creating charts from values, mathematical calculations, or grouping them into arrays. But don\u2019t worry, in this write-up, you\u2019ll learn <strong>how to convert text to number in Excel <\/strong>using 6 different ways.<!--more--><\/p>\n<p>So, without any further ado, let\u2019s get started\u2026<\/p>\n<h2 style=\"text-align: left;\" align=\"center\"><strong>How To Convert Text To Number In Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Follow the below step-by-step methods for converting text to numerical values in MS Excel.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<ul>\n<li style=\"text-align: left;\"><strong><a href=\"#s1\">Use the \u2018Convert to Number\u2019 Option\u00a0<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s2\">Use Paste Special with Multiply<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s3\">Use the \u2018Text to Columns\u2019\u00a0<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s4\">How to Convert the Text to Number with the VALUE Function<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s5\">Excel Convert Text To Number Using VBA<\/a><\/strong><\/li>\n<li style=\"text-align: left;\"><strong><a href=\"#s6\">Changing Cell Format<\/a><\/strong><\/li>\n<\/ul>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 1: Use the \u2018Convert to Number\u2019 Option to Convert Text to Number Excel<\/strong><\/h3>\n<p>The very first way that you can try to convert text to number using the option \u2018<strong>Convert to Number\u2019<\/strong>. This option will eventually help you to convert the data that is been entered in the Excel with an apostrophe.<\/p>\n<p>Here is how you can use this option:<\/p>\n<ul>\n<li>Initially, select the Excel cells that you need to convert to the number format.<\/li>\n<li>Then, you\u2019ll see one yellow diamond exclamation symbol near the selection.<\/li>\n<li>Simply, click on a\u00a0<strong>dropdown\u00a0<\/strong>&gt;&gt; select the option\u00a0\u2018<strong>Convert to Number<\/strong>\u2019.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6789 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0.png\" alt=\"Convert Text To Number In Excel\" width=\"346\" height=\"230\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0.png 346w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-300x199.png 300w\" sizes=\"auto, (max-width: 346px) 100vw, 346px\" \/><\/p>\n<ul>\n<li>Now, you will be getting your text converted to the number.<\/li>\n<\/ul>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 2: Use Paste Special with Multiply<\/strong><\/h3>\n<p>In Microsoft Excel, Paste Special is a fabulous tool that also helps to <strong>convert text to numbers in Excel<\/strong>.<\/p>\n<p>So, here we will use the Paste Special feature to convert the text into numbers and to perform the simple calculation.<\/p>\n<p>Here is how you can do so:<\/p>\n<ul>\n<li>Enter the value 1, in any blank cell.<\/li>\n<li>After that select, the particular cell where you type <strong>1<\/strong> &gt; on the <strong>Edit <\/strong>menu. Click <strong>Copy.<\/strong><\/li>\n<li>And with the <strong>values select the cells<\/strong> that you need to convert to numbers.<\/li>\n<li>Next on <strong>Edit<\/strong> menu &gt;&gt; click <strong>Paste Special.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6790 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-1.png\" alt=\"convert text to number in Excel\" width=\"515\" height=\"466\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-1.png 515w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-1-300x271.png 300w\" sizes=\"auto, (max-width: 515px) 100vw, 515px\" \/><\/p>\n<ul>\n<li>Then under Paste Special operation<strong> &gt;&gt;<\/strong> select All &gt;&gt; click <strong>Multiply <\/strong><strong>&gt;&gt;<\/strong> <strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6791 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-2.png\" alt=\"convert text to number in Excel\" width=\"402\" height=\"333\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-2.png 402w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/pasted-image-0-2-300x249.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><span style=\"color: #ff0000;\"><strong>Note<\/strong><\/span>: If you are getting any issues while pasting your data in the Excel worksheet, check out <a href=\"https:\/\/www.repairmsexcel.com\/blog\/resolve-excel-cannot-copy-paste-data-error\" target=\"_blank\" rel=\"noopener\"><strong>this post<\/strong><\/a>.<\/p>\n<p style=\"text-align: justify;\"><\/div><\/div>\n<p><a name=\"s3\"><\/a><\/p>\n<h3><strong>Way 3: Use the \u2018Text to Columns\u2019\u00a0<\/strong><\/h3>\n<p style=\"text-align: justify;\">This method works best if data is arranged in a single column. The example presumes that the data is in column A and starts in<strong> row 1 ($A$1)<\/strong>.<\/p>\n<p>Follow the steps to do so:<\/p>\n<ul>\n<li>Choose one column of cells that holds the text.<\/li>\n<li>And on the <strong>Data <\/strong>menu &gt; click <strong>Text to Columns<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6792 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1.png\" alt=\"how to convert text to number in Excel\" width=\"1052\" height=\"366\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1.png 1052w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-300x104.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-1024x356.png 1024w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-1-1-768x267.png 768w\" sizes=\"auto, (max-width: 1052px) 100vw, 1052px\" \/><\/p>\n<ul>\n<li>After that under <strong>Original data type &gt;<\/strong> click <strong>Delimited &gt;<\/strong> click <strong>Next.<\/strong><\/li>\n<li>Next under Delimiters &gt; click to choose the <strong>Tab <\/strong>check box &gt; click Next.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6794 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/3-1.png\" alt=\"Column data format\" width=\"507\" height=\"417\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/3-1.png 507w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/3-1-300x247.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<ul>\n<li>And under <strong>Column data format &gt;<\/strong> click <strong>General<\/strong>.<\/li>\n<li>Then click <strong>Advanced <\/strong>&gt; make any appropriate settings for the Decimal separator &gt; Thousands separator and click OK.<\/li>\n<li>Click <strong>Finish.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6793 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-2.png\" alt=\"how to convert text to number in Excel\" width=\"507\" height=\"417\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-2.png 507w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/convert-text-to-columns-2-300x247.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<p style=\"text-align: justify;\">And that all your text is converted to numbers.<\/p>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 4: How to Convert Text to Number in Excel with the VALUE Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">The <strong><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2#:~:text=Text%20can%20be%20in%20any,text%20to%20numbers%20as%20necessary.\" target=\"_blank\" rel=\"noopener nofollow\">VALUE function<\/a><\/strong> is a handy way that can be used for converting the text to numbers.<\/p>\n<p style=\"text-align: justify;\">Here you have to type the below command in the cell:<\/p>\n<blockquote><p><strong>= VALUE (text)<\/strong><\/p><\/blockquote>\n<ul>\n<li><strong>Here, text<\/strong>\u00a0is the value that you need to convert to a numerical value.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6795 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/How-to-Convert-Text-to-Number-in-Excel.png\" alt=\"How to Convert Text to Number in Excel\" width=\"450\" height=\"189\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/How-to-Convert-Text-to-Number-in-Excel.png 450w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/How-to-Convert-Text-to-Number-in-Excel-300x126.png 300w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p style=\"text-align: justify;\">In case, if your text contains non-numerical characters, the VALUE function returns a\u00a0<strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/solve-value-error\" target=\"_blank\" rel=\"noopener\">#VALUE!\u00a0error<\/a><\/strong>. And it doesn\u2019t give you the result that you want.<\/p>\n<blockquote><p><strong>= VALUE (B3)<\/strong><\/p><\/blockquote>\n<p style=\"text-align: justify;\">Now, the above formula can be used to convert text in the Excel cell B3 to a numerical value and then copy &amp; paste a formula in order to convert the complete column.<\/p>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 5: <\/strong><strong>Excel Convert Text To Number Using VBA<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another very interesting way to make your Convert Text to Numerical values is by using the VBA code. It is well applicable to Excel 2003\/2007 application version.<\/p>\n<p style=\"text-align: justify;\">\u00a0It is found that in many cases all the above-mentioned solution fails to work. Well in a such situation, using VBA works great.<\/p>\n<p style=\"text-align: justify;\">The following VBA Macro code is provided on the Microsoft page to make <strong>Excel convert Text to Number.<\/strong><\/p>\n<blockquote><p><strong>\u00a0<em>Sub Enter_Values()<\/em><\/strong><\/p>\n<p><strong><em>\u00a0For Each xCell In Selection<\/em><\/strong><\/p>\n<p><strong><em>\u00a0xCell.Value = xCell.Value<\/em><\/strong><\/p>\n<p><strong><em>Next xCell<\/em><\/strong><\/p>\n<p><strong><em>End Sub<\/em><\/strong><\/p><\/blockquote>\n<p style=\"text-align: justify;\">If in case the above VBA code shows an error on execution, then you need to do the following changes in coding:<\/p>\n<blockquote><p><strong><em>\u00a0For Each xCell In Selection<\/em><\/strong><\/p>\n<p><strong><em>\u00a0xCell.Value = CDec(xCell.Value)<\/em><\/strong><\/p>\n<p><strong><em>Next xCell<\/em><\/strong><\/p><\/blockquote>\n<p><a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 6: Changing Cell Format<\/strong><\/h3>\n<p style=\"text-align: justify;\">Changing the cell format is another yet way that can assist you to convert text to number Excel successfully.<\/p>\n<ul>\n<li>For this, you have to right-click on the cell(s).<\/li>\n<li>Click on \u201c<strong>Format Cells<\/strong>.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6797 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/2.png\" alt=\"Format Cells Excel\" width=\"604\" height=\"467\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/2.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/2-300x232.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul>\n<li>After this, choose \u201cNumber\u201d tab &gt;&gt; click on \u201c<strong>Number<\/strong>\u201d on a left.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6796 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/1.png\" alt=\"Changing Cell Format\" width=\"542\" height=\"469\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/1.png 542w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/12\/1-300x260.png 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/p>\n<ul>\n<li>Now, you can adjust the Decimal Places &gt;&gt; click \u201c<strong>OK<\/strong>.\u201d<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Shortcut to Convert to Number in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe <strong>Ctrl + Alt + V<\/strong> is the shortcut to convert to numbers. All you need to do is to select the cells that you need to convert to numbers, then press the Ctrl + Alt + V keys simultaneously.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Convert Text to Number in Excel VLOOKUP?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tBy using the Value Function, you can convert the text to number in Excel VLOOKUP.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Convert Text to Number in Excel Cell?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can convert text to number in Excel cell using the Paste Special feature, error checking, or Value Function.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Shortcut to Convert to Number in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The <strong>Ctrl + Alt + V<\/strong> is the shortcut to convert to numbers. All you need to do is to select the cells that you need to convert to numbers, then press the Ctrl + Alt + V keys simultaneously.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Convert Text to Number in Excel VLOOKUP?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"By using the Value Function, you can convert the text to number in Excel VLOOKUP.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Convert Text to Number in Excel Cell?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can convert text to number in Excel cell using the Paste Special feature, error checking, or Value Function.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<blockquote>\n<p style=\"text-align: center;\"><strong>Also Read: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-access-to-excel\">How to Convert Access To Excel File? [The Definitive Guide]<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>To Sum Up<\/strong><\/h2>\n<p style=\"text-align: justify;\">Well, this is all about <strong>how to convert text to number in Excel <\/strong>in easy ways. I tried my level best to put together the possible steps that will help you out.<\/p>\n<p style=\"text-align: justify;\">All you need to do is to follow the given steps one by one and convert text to number in MS Excel effortlessly.<\/p>\n<p style=\"text-align: justify;\">Thanks for reading this post!<\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>It is quite a frustrating situation when the numbers are formatted or stored as text in an Excel spreadsheet. Due &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Convert Text to Number in Excel (6 Easy Ways)\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#more-1525\" aria-label=\"Read more about How to Convert Text to Number in Excel (6 Easy Ways)\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":6800,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[1438,1439,737,736],"class_list":["post-1525","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-convert-text-to-number-excel","tag-convert-text-to-number-in-excel-using-formula","tag-excel-convert-text-to-number","tag-how-to-convert-text-to-number-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Convert Text to Number in Excel (6 Easy Ways)<\/title>\n<meta name=\"description\" content=\"How to Excel convert text to numbers? Follow the step-by-step methods mentioned here in this post to convert text to number in Excel easily\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Convert Text to Number in Excel (6 Easy Ways)\" \/>\n<meta property=\"og:description\" content=\"How to Excel convert text to numbers? Follow the step-by-step methods mentioned here in this post to convert text to number in Excel easily\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-14T07:17:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-14T07:57:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"321\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Convert Text to Number in Excel (6 Easy Ways)\",\"datePublished\":\"2023-03-14T07:17:06+00:00\",\"dateModified\":\"2023-11-14T07:57:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\"},\"wordCount\":1032,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png\",\"keywords\":[\"convert text to number Excel\",\"convert text to number in excel using formula\",\"excel convert text to number\",\"How To Convert Text To Number In Excel\"],\"articleSection\":[\"Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\",\"name\":\"How to Convert Text to Number in Excel (6 Easy Ways)\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png\",\"datePublished\":\"2023-03-14T07:17:06+00:00\",\"dateModified\":\"2023-11-14T07:57:50+00:00\",\"description\":\"How to Excel convert text to numbers? Follow the step-by-step methods mentioned here in this post to convert text to number in Excel easily\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png\",\"width\":550,\"height\":321,\"caption\":\"How to Convert Text to Number in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Convert Text to Number in Excel (6 Easy Ways)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Convert Text to Number in Excel (6 Easy Ways)","description":"How to Excel convert text to numbers? Follow the step-by-step methods mentioned here in this post to convert text to number in Excel easily\u2026","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:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Convert Text to Number in Excel (6 Easy Ways)","og_description":"How to Excel convert text to numbers? Follow the step-by-step methods mentioned here in this post to convert text to number in Excel easily\u2026","og_url":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2023-03-14T07:17:06+00:00","article_modified_time":"2023-11-14T07:57:50+00:00","og_image":[{"width":550,"height":321,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Convert Text to Number in Excel (6 Easy Ways)","datePublished":"2023-03-14T07:17:06+00:00","dateModified":"2023-11-14T07:57:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel"},"wordCount":1032,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png","keywords":["convert text to number Excel","convert text to number in excel using formula","excel convert text to number","How To Convert Text To Number In Excel"],"articleSection":["Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel","name":"How to Convert Text to Number in Excel (6 Easy Ways)","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png","datePublished":"2023-03-14T07:17:06+00:00","dateModified":"2023-11-14T07:57:50+00:00","description":"How to Excel convert text to numbers? Follow the step-by-step methods mentioned here in this post to convert text to number in Excel easily\u2026","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/03\/Convert-Text-To-Numbers-In-Excel-copy-1.png","width":550,"height":321,"caption":"How to Convert Text to Number in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/convert-text-to-number-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Convert Text to Number in Excel (6 Easy Ways)"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=1525"}],"version-history":[{"count":1,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1525\/revisions"}],"predecessor-version":[{"id":7374,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1525\/revisions\/7374"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/6800"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=1525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=1525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=1525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}