{"id":6696,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/valeurnombre\/"},"modified":"2021-02-26T08:11:13","modified_gmt":"2021-02-26T08:11:13","slug":"numbervalue","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/numbervalue\/","title":{"rendered":"VALEURNOMBRE"},"content":{"rendered":"<h2>Description et syntaxe de la fonction<\/h2>\n<p>La fonction <strong>VALEURNOMBRE<\/strong> dans Excel et Google Sheets permet de convertir une cha\u00eene de caract\u00e8res en nombre. Cela s&rsquo;av\u00e8re tr\u00e8s utile pour traiter des donn\u00e9es num\u00e9riques qui sont import\u00e9es ou copi\u00e9es sous forme de texte. Cette fonction offre \u00e9galement la possibilit\u00e9 de d\u00e9finir les s\u00e9parateurs de d\u00e9cimales et de milliers, ce qui permet d\u2019ajuster le formatage des nombres en fonction des exigences locales ou sp\u00e9cifiques.<\/p>\n<p>La syntaxe de la fonction est la suivante :<\/p>\n<pre><code>VALEURNOMBRE(texte; [s\u00e9parateur_d\u00e9cimal]; [s\u00e9parateur_de_milliers])<\/code><\/pre>\n<ul>\n<li><strong>texte<\/strong> : La cha\u00eene de caract\u00e8res que vous souhaitez convertir en nombre. Ce param\u00e8tre est obligatoire.<\/li>\n<li><strong>s\u00e9parateur_d\u00e9cimal<\/strong> : Le caract\u00e8re utilis\u00e9 pour indiquer la position des d\u00e9cimales dans le texte. Ce param\u00e8tre est facultatif.<\/li>\n<li><strong>s\u00e9parateur_de_milliers<\/strong> : Le caract\u00e8re utilis\u00e9 pour s\u00e9parer les groupes de mille dans le texte. Ce param\u00e8tre est \u00e9galement facultatif.<\/li>\n<\/ul>\n<h2>Exemples d&rsquo;utilisation pratiques<\/h2>\n<p>Ci-dessous, vous trouverez plusieurs sc\u00e9narios o\u00f9 la fonction <strong>VALEURNOMBRE<\/strong> peut \u00eatre particuli\u00e8rement b\u00e9n\u00e9fique :<\/p>\n<h2>Cas pratique 1 : Conversion de donn\u00e9es mon\u00e9taires<\/h2>\n<p>Imaginez que vous recevez des donn\u00e9es sous forme de texte pour des montants financiers d&rsquo;une application o\u00f9 le point est utilis\u00e9 pour les milliers et la virgule pour les d\u00e9cimales, par exemple \u00ab\u00a01.234,56\u00a0\u00bb.<\/p>\n<pre><code>=VALEURNOMBRE(\"1.234,56\"; \",\"; \".\")<\/code><\/pre>\n<p>Cette formule transforme la cha\u00eene de caract\u00e8res \u00ab\u00a01.234,56\u00a0\u00bb en le nombre 1234,56, pr\u00eat \u00e0 \u00eatre utilis\u00e9 dans des op\u00e9rations num\u00e9riques dans votre feuille de calcul.<\/p>\n<h2>Cas pratique 2 : Importation de donn\u00e9es num\u00e9riques avec diff\u00e9rents formats<\/h2>\n<p>Supposons que vous devez g\u00e9rer un fichier d&rsquo;importation contenant des formats num\u00e9riques vari\u00e9s comme \u00ab\u00a01.234,56\u00a0\u00bb, \u00ab\u00a02,345.67\u00a0\u00bb et \u00ab\u00a07 890,12\u00a0\u00bb. Il est n\u00e9cessaire d&rsquo;uniformiser ces valeurs pour analyse.<\/p>\n<pre><code>=VALEURNOMBRE(\"2,345.67\"; \".\"; \",\") =VALEURNOMBRE(\"7 890,12\"; \",\"; \" \")<\/code><\/pre>\n<p>Dans le premier exemple, les nombres sont format\u00e9s avec une virgule comme s\u00e9parateur de milliers et un point pour les d\u00e9cimales. Dans le second exemple, un espace est utilis\u00e9 pour s\u00e9parer les milliers. L&rsquo;utilisation de la fonction <strong>VALEURNOMBRE<\/strong> avec les param\u00e8tres corrects permet de convertir ces textes en nombres utilisables pour des analyses ult\u00e9rieures.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Convertit du texte en nombre d\u2019une mani\u00e8re ind\u00e9pendante des param\u00e8tres r\u00e9gionaux<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[314],"tags":[],"class_list":["post-6696","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NUMBERVALUE (VALEURNOMBRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/numbervalue\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NUMBERVALUE (VALEURNOMBRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/numbervalue\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:11:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/numbervalue\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/numbervalue\/\",\"name\":\"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:11:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NUMBERVALUE (VALEURNOMBRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/numbervalue\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/numbervalue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/numbervalue\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Texte\",\"item\":\"https:\/\/functiontranslator.com\/fr\/texte\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VALEURNOMBRE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NUMBERVALUE (VALEURNOMBRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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:\/\/functiontranslator.com\/fr\/numbervalue\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NUMBERVALUE (VALEURNOMBRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/numbervalue\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/numbervalue\/","url":"https:\/\/functiontranslator.com\/fr\/numbervalue\/","name":"Fonction NUMBERVALUE (VALEURNOMBRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:11:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NUMBERVALUE (VALEURNOMBRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/numbervalue\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/numbervalue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/numbervalue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Texte","item":"https:\/\/functiontranslator.com\/fr\/texte\/"},{"@type":"ListItem","position":3,"name":"VALEURNOMBRE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6696"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6696\/revisions"}],"predecessor-version":[{"id":29707,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6696\/revisions\/29707"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}