{"id":6830,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-valuetotext\/"},"modified":"2021-02-26T08:15:54","modified_gmt":"2021-02-26T08:15:54","slug":"valuetotext","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/valuetotext\/","title":{"rendered":"VALUETOTEXT"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction VALUETOTEXT<\/code> disponible sur Google Sheets et dans certaines versions r\u00e9centes de Microsoft Excel permet de convertir une valeur num\u00e9rique en texte. Cette fonction se r\u00e9v\u00e8le particuli\u00e8rement pratique pour formater des donn\u00e9es en vue de leur affichage ou lorsqu’une repr\u00e9sentation textuelle de valeurs num\u00e9riques est requise.<\/p>\n

Syntaxe de la fonction :<\/p>\n

VALUETOTEXT(valeur)<\/code><\/pre>\n
    \n
  • valeur<\/strong> : Il s’agit de la valeur \u00e0 convertir en texte. Cette valeur peut \u00eatre une r\u00e9f\u00e9rence \u00e0 une cellule contenant un nombre, une date, une valeur logique, ou le r\u00e9sultat d’une formule.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Ci-dessous, quelques exemples d\u00e9montrent l’utilisation de la fonction VALUETOTEXT<\/code> dans des feuilles de calcul.<\/p>\n\n\n\n\n\n
    Expression<\/th>\nR\u00e9sultat<\/th>\nDescription<\/th>\n<\/tr>\n
    =VALUETOTEXT(123)<\/code><\/td>\n\u00ab\u00a0123\u00a0\u00bb<\/td>\nConvertit le nombre 123 en texte.<\/td>\n<\/tr>\n
    =VALUETOTEXT(450*3.14)<\/code><\/td>\n\u00ab\u00a01413\u00a0\u00bb<\/td>\nCalcule le produit de 450 par 3.14 et convertit le r\u00e9sultat en texte.<\/td>\n<\/tr>\n
    =VALUETOTEXT(VRAI)<\/code><\/td>\n\u00ab\u00a0VRAI\u00a0\u00bb<\/td>\nConvertit la valeur logique VRAI en texte.<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Explorons quelques applications concr\u00e8tes de la fonction VALUETOTEXT<\/code>.<\/p>\n
    Sc\u00e9nario 1 : G\u00e9n\u00e9ration de r\u00e9f\u00e9rences uniques<\/h3>\n
    Supposons que vous devez cr\u00e9er des r\u00e9f\u00e9rences uniques pour chaque transaction dans un registre de ventes. Vous pourriez formater chaque r\u00e9f\u00e9rence avec le pr\u00e9fixe \u00ab\u00a0TRANS\u00a0\u00bb suivi de l’identifiant num\u00e9rique de la transaction.<\/p>\n
    =CONCAT(\"TRANS\", VALUETOTEXT(A2))<\/code><\/pre>\n
    Ici, A2<\/code> contient l’identifiant de la transaction. Cette formule convertit cet identifiant num\u00e9rique en texte et l’associe au pr\u00e9fixe \u00ab\u00a0TRANS\u00a0\u00bb, formant ainsi une r\u00e9f\u00e9rence en format textuel.<\/p>\n
    Sc\u00e9nario 2 : Affichage uniforme des num\u00e9ros de t\u00e9l\u00e9phone<\/h3>\n
    Imaginez que vous devez pr\u00e9senter les num\u00e9ros de t\u00e9l\u00e9phone de mani\u00e8re uniforme, ind\u00e9pendamment du fait qu’ils incluent ou non l’indicatif international. L’utilisation de VALUETOTEXT<\/code> vous permet de traiter tous les num\u00e9ros comme du texte et d’ajouter un indicatif par d\u00e9faut si n\u00e9cessaire.<\/p>\n
    =IF(LEN(VALUETOTEXT(A2))=10, CONCAT(\"+33\", VALUETOTEXT(A2)), VALUETOTEXT(A2))<\/code><\/pre>\n
    Cet exemple ajoute \u00ab\u00a0+33\u00a0\u00bb aux num\u00e9ros ayant pr\u00e9cis\u00e9ment 10 chiffres, tout en conservant les autres formats inchang\u00e9s, assurant ainsi une uniformit\u00e9 id\u00e9ale pour un affichage clair et coh\u00e9rent.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le texte de n\u2019importe quelle valeur sp\u00e9cifi\u00e9e<\/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-6830","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction VALUETOTEXT dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction VALUETOTEXT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'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\/valuetotext\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction VALUETOTEXT dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction VALUETOTEXT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/valuetotext\/\" \/>\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:15:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction VALUETOTEXT 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\/valuetotext\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/valuetotext\/\",\"name\":\"Fonction VALUETOTEXT 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:15:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction VALUETOTEXT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/valuetotext\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/valuetotext\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/valuetotext\/#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\":\"VALUETOTEXT\"}]},{\"@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 VALUETOTEXT dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction VALUETOTEXT 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\/valuetotext\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction VALUETOTEXT dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction VALUETOTEXT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/valuetotext\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction VALUETOTEXT 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\/valuetotext\/","url":"https:\/\/functiontranslator.com\/fr\/valuetotext\/","name":"Fonction VALUETOTEXT 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:15:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction VALUETOTEXT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/valuetotext\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/valuetotext\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/valuetotext\/#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":"VALUETOTEXT"}]},{"@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\/6830","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=6830"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6830\/revisions"}],"predecessor-version":[{"id":29839,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6830\/revisions\/29839"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}