{"id":6452,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/convert\/"},"modified":"2021-02-26T08:03:31","modified_gmt":"2021-02-26T08:03:31","slug":"convert","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/convert\/","title":{"rendered":"CONVERT"},"content":{"rendered":"

Description g\u00e9n\u00e9rale<\/h2>\n

La fonction CONVERT est disponible dans Excel et Google Sheets et permet de convertir facilement des quantit\u00e9s entre diff\u00e9rentes unit\u00e9s de mesure. Cette fonction est essentielle dans des secteurs tels que les sciences, l’ing\u00e9nierie ou la gastronomie, o\u00f9 l’utilisation de multiples syst\u00e8mes d’unit\u00e9s est courante.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction CONVERT :<\/p>\n

CONVERT(nombre, \"unit\u00e9_de_base\", \"unit\u00e9_voulue\")<\/code><\/pre>\n
Dans cette formule, ‘nombre’ d\u00e9signe la quantit\u00e9 que vous souhaitez convertir, ‘unit\u00e9_de_base’ repr\u00e9sente l’unit\u00e9 actuelle de cette quantit\u00e9, et ‘unit\u00e9_voulue’ l’unit\u00e9 dans laquelle vous souhaitez effectuer la conversion.<\/p>\n
Exemple :<\/p>\n
=CONVERT(100, \"m\", \"km\")<\/code><\/pre>\n
Cette formule convertit 100 m\u00e8tres en kilom\u00e8tres.<\/p>\n
Exemples pratiques<\/h2>\n
Ci-dessous, d\u00e9couvrez deux sc\u00e9narios illustrant l’application de la fonction CONVERT.<\/p>\n
Sc\u00e9nario 1 : Conversion des temp\u00e9ratures<\/h2>\n
Imaginons que vous poss\u00e9diez une s\u00e9rie de temp\u00e9ratures en degr\u00e9s Fahrenheit n\u00e9cessitant une conversion en degr\u00e9s Celsius pour un rapport scientifique.<\/p>\n
    \n
  • Temp\u00e9rature en Fahrenheit : 98.6<\/li>\n
  • Formule pour la conversion : =CONVERT(98.6, \"F\", \"C\")<\/code><\/li>\n
  • R\u00e9sultat de la conversion : 37\u00b0C<\/li>\n<\/ul>\n
    Commentaire :
     Cette formule trouve particuli\u00e8rement son utilit\u00e9 dans des domaines comme la m\u00e9decine ou la m\u00e9t\u00e9orologie o\u00f9 la conversion de temp\u00e9ratures est souvent requise pour des analyses d\u00e9taill\u00e9es.<\/p>\n
    Sc\u00e9nario 2 : Conversion d’unit\u00e9s de poids en cuisine<\/h2>\n
    Si vous devez convertir des onces en grammes pour adapter une recette internationale :<\/p>\n
      \n
    • Poids en onces : 8 oz<\/li>\n
    • Formule pour la conversion : =CONVERT(8, \"ozm\", \"g\")<\/code><\/li>\n
    • R\u00e9sultat de la conversion : environ 226.8 grammes<\/li>\n<\/ul>\n
      Commentaire :
       La conversion d’unit\u00e9s de poids est indispensable en cuisine, notamment lorsque l’on utilise des recettes provenant de pays avec des syst\u00e8mes d’unit\u00e9s diff\u00e9rents. Cela assure la pr\u00e9cision n\u00e9cessaire pour les proportions des ingr\u00e9dients.<\/p>\n
      Conclusion<\/h2>\n
      La fonction CONVERT dans Excel et Google Sheets s’av\u00e8re tr\u00e8s utile pour manipuler et convertir des unit\u00e9s de mesure dans une vari\u00e9t\u00e9 de domaines. Elle offre la flexibilit\u00e9 et la pr\u00e9cision n\u00e9cessaires pour le traitement et l’analyse de donn\u00e9es diversifi\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Convertit un nombre d\u2019une unit\u00e9 de mesure \u00e0 une autre<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316],"tags":[],"class_list":["post-6452","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction CONVERT dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CONVERT 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\/convert\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONVERT dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CONVERT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/convert\/\" \/>\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:03:31+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CONVERT 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\/convert\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/convert\/\",\"name\":\"Fonction CONVERT 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:03:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CONVERT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/convert\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/convert\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/convert\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ing\u00e9nierie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/ingenierie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CONVERT\"}]},{\"@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 CONVERT dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CONVERT 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\/convert\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONVERT dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CONVERT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/convert\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CONVERT 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\/convert\/","url":"https:\/\/functiontranslator.com\/fr\/convert\/","name":"Fonction CONVERT 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:03:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CONVERT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/convert\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/convert\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/convert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Ing\u00e9nierie","item":"https:\/\/functiontranslator.com\/fr\/ingenierie\/"},{"@type":"ListItem","position":3,"name":"CONVERT"}]},{"@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\/6452","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=6452"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6452\/revisions"}],"predecessor-version":[{"id":29464,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6452\/revisions\/29464"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}