{"id":647,"date":"2014-01-11T14:15:39","date_gmt":"2014-01-11T14:15:39","guid":{"rendered":"https:\/\/www.dsconsultant.net\/blog\/?p=647"},"modified":"2014-01-11T19:28:47","modified_gmt":"2014-01-11T19:28:47","slug":"convertir-du-texte-en-nombres-dans-excel","status":"publish","type":"post","link":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel","title":{"rendered":"convertir du texte en nombres dans Excel"},"content":{"rendered":"<div>\n<h4>Comment faire pour convertir rapidement chiffre reconnus comme du texte en nombres dans Excel ?<\/h4>\n<p>Il arrive qu&rsquo;apr\u00e8s une importation on se retrouve avec des nombres reconnu comme du texte dans des cellules et donc impossible \u00e0 utiliser dans des formules.<br \/>\nIl existe plusieurs m\u00e9thodes mais personnellement j&rsquo;utilise ces 2 l\u00e0 :<!--more--><\/p>\n<\/div>\n<div>\n<div>\n<div>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>1\u00e8re m\u00e9tode :<\/strong><\/span> Taper 1 dans une cellule vierge -&gt; la copier -&gt; s\u00e9lectionner les cellules contenant les nombres reconnus comme du texte et faire Collage sp\u00e9cial Op\u00e9ration Multiplication<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>2\u00e8me m\u00e9thode :<\/strong><\/span> (tr\u00e8s pratique si les nombres sont sur une seule colonne sinon \u00e0 r\u00e9p\u00e9ter autant de fois que de colonnes)<br \/>\nS\u00e9lectionner les nombres de la colonne -&gt; Menu Donn\u00e9es -&gt; Convertir et cliquer directement sur Terminer ou Fin<\/p>\n<div>\n<div>\n<div><\/div>\n<div>D\u00e9tails en images :<\/div>\n<div><\/div>\n<div><strong>1\u00e8re m\u00e9tode :<\/strong><\/div>\n<div>Taper 1 dans une cellule vierge -&gt; la copier -&gt;<\/div>\n<div id=\"AppleMailSignature\">\u00a0<a href=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?ssl=1\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-665\" alt=\"PastedGraphic-11\" src=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?resize=300%2C117&#038;ssl=1\" width=\"300\" height=\"117\" srcset=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?resize=300%2C117&amp;ssl=1 300w, https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?w=379&amp;ssl=1 379w\" sizes=\"(max-width: 300px) 100vw, 300px\" data-recalc-dims=\"1\" \/><\/a><\/div>\n<div>\u00a0s\u00e9lectionner les cellules contenant les nombres reconnus comme du texte<\/div>\n<div><a href=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-12.png?ssl=1\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-664\" alt=\"PastedGraphic-12\" src=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-12.png?resize=300%2C131&#038;ssl=1\" width=\"300\" height=\"131\" srcset=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-12.png?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-12.png?w=382&amp;ssl=1 382w\" sizes=\"(max-width: 300px) 100vw, 300px\" data-recalc-dims=\"1\" \/><\/a><\/div>\n<div>et faire Collage sp\u00e9cial Op\u00e9ration Multiplication<\/div>\n<div><a href=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-10.png?ssl=1\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-666\" alt=\"PastedGraphic-10\" src=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-10.png?resize=300%2C286&#038;ssl=1\" width=\"300\" height=\"286\" srcset=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-10.png?resize=300%2C286&amp;ssl=1 300w, https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-10.png?w=398&amp;ssl=1 398w\" sizes=\"(max-width: 300px) 100vw, 300px\" data-recalc-dims=\"1\" \/><br \/>\n<\/a><\/div>\n<div>\n<p>les nombres sont instantan\u00e9ment convertis en nombre et donc utilisables normalement dans les sommes et autres formules<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-14.png?ssl=1\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-669\" alt=\"PastedGraphic-14\" src=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-14.png?resize=300%2C136&#038;ssl=1\" width=\"300\" height=\"136\" srcset=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-14.png?resize=300%2C136&amp;ssl=1 300w, https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-14.png?w=386&amp;ssl=1 386w\" sizes=\"(max-width: 300px) 100vw, 300px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p><strong>2\u00e8me m\u00e9thode :<\/strong>\u00a0\u00a0(tr\u00e8s pratique si les nombres sont sur une seule colonne sinon \u00e0 r\u00e9p\u00e9ter autant de fois que de colonnes)<\/p>\n<p>S\u00e9lectionner les nombres de la colonne<br \/>\n-&gt; Menu Donn\u00e9es -&gt; Convertir<\/p>\n<p><a href=\"https:\/\/i2.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-15.png?ssl=1\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-667\" alt=\"PastedGraphic-15\" src=\"https:\/\/i2.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-15.png?resize=242%2C300&#038;ssl=1\" width=\"242\" height=\"300\" srcset=\"https:\/\/i2.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-15.png?resize=242%2C300&amp;ssl=1 242w, https:\/\/i2.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-15.png?w=311&amp;ssl=1 311w\" sizes=\"(max-width: 242px) 100vw, 242px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>et cliquer directement sur Terminer ou Fin<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-16.png?ssl=1\"><img loading=\"lazy\" class=\"aligncenter size-medium wp-image-668\" alt=\"PastedGraphic-16\" src=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-16.png?resize=300%2C289&#038;ssl=1\" width=\"300\" height=\"289\" srcset=\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-16.png?resize=300%2C289&amp;ssl=1 300w, https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-16.png?w=451&amp;ssl=1 451w\" sizes=\"(max-width: 300px) 100vw, 300px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Comment faire pour convertir rapidement chiffre reconnus comme du texte en nombres dans Excel ? Il arrive qu&rsquo;apr\u00e8s une importation on se retrouve avec des nombres reconnu comme du texte dans des cellules et donc impossible \u00e0 utiliser dans des formules. Il existe plusieurs m\u00e9thodes mais personnellement j&rsquo;utilise ces 2 l\u00e0 :<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[35],"tags":[41,43,42],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>convertir du texte en nombres dans Excel - Mes Notes, Astuces &amp; Conseils informatiques<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"convertir du texte en nombres dans Excel - Mes Notes, Astuces &amp; Conseils informatiques\" \/>\n<meta property=\"og:description\" content=\"Comment faire pour convertir rapidement chiffre reconnus comme du texte en nombres dans Excel ? Il arrive qu&rsquo;apr\u00e8s une importation on se retrouve avec des nombres reconnu comme du texte dans des cellules et donc impossible \u00e0 utiliser dans des formules. Il existe plusieurs m\u00e9thodes mais personnellement j&rsquo;utilise ces 2 l\u00e0 :\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel\" \/>\n<meta property=\"og:site_name\" content=\"Mes Notes, Astuces &amp; Conseils informatiques\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dsconsultant.net\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-11T14:15:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-01-11T19:28:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11-300x117.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dominique Schos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/#website\",\"url\":\"https:\/\/dsconsultant.net\/blog\/\",\"name\":\"Mes Notes, Astuces &amp; Conseils informatiques\",\"description\":\"Dominique Schos Consultant Conseil informatique Maroc\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dsconsultant.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?fit=379%2C148&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?fit=379%2C148&ssl=1\",\"width\":379,\"height\":148},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#webpage\",\"url\":\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel\",\"name\":\"convertir du texte en nombres dans Excel - Mes Notes, Astuces &amp; Conseils informatiques\",\"isPartOf\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#primaryimage\"},\"datePublished\":\"2014-01-11T14:15:39+00:00\",\"dateModified\":\"2014-01-11T19:28:47+00:00\",\"author\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92\"},\"breadcrumb\":{\"@id\":\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/dsconsultant.net\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"convertir du texte en nombres dans Excel\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92\",\"name\":\"Dominique Schos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g\",\"caption\":\"Dominique Schos\"},\"description\":\"De MacOS 1.0 en 1984 \u00e0 OSX12 Monteray en passant par le mythique OSX, de MS-DOS 1 \u00e0 Windows11, de IOS Apple \u00e0 Android, des premiers \\\"Tchat\\\" sur ICQ \u00e0 Facebook Live, je ne me lasse pas de \\\"flirter\\\" avec ces technologies et moyens de communications que j'aime mettre \u00e0 votre service...\",\"sameAs\":[\"https:\/\/www.dsconsultant.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"convertir du texte en nombres dans Excel - Mes Notes, Astuces &amp; Conseils informatiques","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:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel","og_locale":"fr_FR","og_type":"article","og_title":"convertir du texte en nombres dans Excel - Mes Notes, Astuces &amp; Conseils informatiques","og_description":"Comment faire pour convertir rapidement chiffre reconnus comme du texte en nombres dans Excel ? Il arrive qu&rsquo;apr\u00e8s une importation on se retrouve avec des nombres reconnu comme du texte dans des cellules et donc impossible \u00e0 utiliser dans des formules. Il existe plusieurs m\u00e9thodes mais personnellement j&rsquo;utilise ces 2 l\u00e0 :","og_url":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel","og_site_name":"Mes Notes, Astuces &amp; Conseils informatiques","article_publisher":"https:\/\/www.facebook.com\/dsconsultant.net\/","article_published_time":"2014-01-11T14:15:39+00:00","article_modified_time":"2014-01-11T19:28:47+00:00","og_image":[{"url":"https:\/\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11-300x117.png"}],"twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Dominique Schos","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/dsconsultant.net\/blog\/#website","url":"https:\/\/dsconsultant.net\/blog\/","name":"Mes Notes, Astuces &amp; Conseils informatiques","description":"Dominique Schos Consultant Conseil informatique Maroc","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dsconsultant.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#primaryimage","url":"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?fit=379%2C148&ssl=1","contentUrl":"https:\/\/i0.wp.com\/dsconsultant.net\/blog\/wp-content\/uploads\/PastedGraphic-11.png?fit=379%2C148&ssl=1","width":379,"height":148},{"@type":"WebPage","@id":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#webpage","url":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel","name":"convertir du texte en nombres dans Excel - Mes Notes, Astuces &amp; Conseils informatiques","isPartOf":{"@id":"https:\/\/dsconsultant.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#primaryimage"},"datePublished":"2014-01-11T14:15:39+00:00","dateModified":"2014-01-11T19:28:47+00:00","author":{"@id":"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92"},"breadcrumb":{"@id":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dsconsultant.net\/blog\/trucs-et-astuces\/convertir-du-texte-en-nombres-dans-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/dsconsultant.net\/blog"},{"@type":"ListItem","position":2,"name":"convertir du texte en nombres dans Excel"}]},{"@type":"Person","@id":"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/09f4f57c32b2145fdea40e17b1ea7e92","name":"Dominique Schos","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/dsconsultant.net\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5df6b5e6cea471da661f13bc21e3e889?s=96&d=mm&r=g","caption":"Dominique Schos"},"description":"De MacOS 1.0 en 1984 \u00e0 OSX12 Monteray en passant par le mythique OSX, de MS-DOS 1 \u00e0 Windows11, de IOS Apple \u00e0 Android, des premiers \"Tchat\" sur ICQ \u00e0 Facebook Live, je ne me lasse pas de \"flirter\" avec ces technologies et moyens de communications que j'aime mettre \u00e0 votre service...","sameAs":["https:\/\/www.dsconsultant.net"]}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/posts\/647"}],"collection":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/comments?post=647"}],"version-history":[{"count":0,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/posts\/647\/revisions"}],"wp:attachment":[{"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/media?parent=647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/categories?post=647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dsconsultant.net\/blog\/wp-json\/wp\/v2\/tags?post=647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}