{"id":6577,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/hexdec\/"},"modified":"2021-02-26T08:07:21","modified_gmt":"2021-02-26T08:07:21","slug":"hex2dec","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/hex2dec\/","title":{"rendered":"HEXDEC"},"content":{"rendered":"

La fonction HEX2DEC, \u00e9galement connue sous le nom HEXDEC, dans Microsoft Excel et Google Sheets permet de convertir un nombre hexad\u00e9cimal en un nombre d\u00e9cimal. Cette fonction est extr\u00eamement pratique dans des domaines tels que l’informatique o\u00f9 le syst\u00e8me hexad\u00e9cimal est couramment employ\u00e9.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction HEX2DEC est la suivante :<\/p>\n

=HEX2DEC(nombre_hexad\u00e9cimal)<\/code><\/pre>\n
o\u00f9 nombre_hexad\u00e9cimal<\/code> repr\u00e9sente une cha\u00eene de caract\u00e8res indiquant le nombre en base 16 \u00e0 convertir en base 10.<\/p>\n
Note :<\/strong> Dans Excel et Google Sheets, le nombre hexad\u00e9cimal doit \u00eatre exprim\u00e9 sous forme de cha\u00eene de caract\u00e8res allant de FFFFFFFF80000000 \u00e0 7FFFFFFF en notation hexad\u00e9cimale. Ceci correspond \u00e0 une gamme de -2,147,483,648 \u00e0 +2,147,483,647 en notation d\u00e9cimale.<\/p>\n
Exemples de base<\/h2>\n
    \n
  • \n
    =HEX2DEC(\"1A\")<\/code><\/pre>\n
    R\u00e9sultat: 26<\/li>\n
  • \n
    =HEX2DEC(\"FFFF\")<\/code><\/pre>\n
    R\u00e9sultat: 65535<\/li>\n
  • \n
    =HEX2DEC(\"FFFFFFFF\")<\/code><\/pre>\n
    R\u00e9sultat: -1 (Illustration d’une conversion avec signe)<\/li>\n<\/ul>\n
    Sc\u00e9nario d’utilisation pratique<\/h2>\n
    Examinons maintenant deux sc\u00e9narios pratiques illustrant l’utilisation de la fonction HEX2DEC.<\/p>\n
    Premier sc\u00e9nario : Conversion de donn\u00e9es de capteur<\/h2>\n
    Supposons que vous travaillez avec un microcontr\u00f4leur \u00e9mettant des donn\u00e9es en hexad\u00e9cimal. Ces donn\u00e9es sont recueillies dans une feuille de calcul pour analyse. Voici comment convertir ces donn\u00e9es hexad\u00e9cimales en d\u00e9cimales :<\/p>\n
     A B 1 Donn\u00e9es hex Donn\u00e9es d\u00e9c 2 1F7 =HEX2DEC(A2) 3 2AA =HEX2DEC(A3) <\/code><\/pre>\n
    Dans cet exemple, les donn\u00e9es hexad\u00e9cimales de la colonne A sont transform\u00e9es en d\u00e9cimales dans la colonne B gr\u00e2ce \u00e0 la fonction HEX2DEC.<\/p>\n
    Deuxi\u00e8me sc\u00e9nario : D\u00e9bogage de code<\/h2>\n
    Imaginez que vous soyez d\u00e9veloppeur analysant des journaux contenant des adresses m\u00e9moire en hexad\u00e9cimal. Pour mieux appr\u00e9hender les \u00e9carts entre diff\u00e9rentes adresses, vous pourriez convertir ces valeurs en d\u00e9cimal.<\/p>\n
     A B 1 Adresse hex Adresse d\u00e9c 2 ABC1 =HEX2DEC(A2) 3 ABCD =HEX2DEC(A3) <\/code><\/pre>\n
    En convertissant les adresses hexad\u00e9cimales en d\u00e9cimales avec HEX2DEC, il devient plus facile de d\u00e9tecter des patterns ou des anomalies dans les blocs de m\u00e9moire.<\/p>\n
    Ces exemples montrent comment la fonction HEX2DEC peut \u00eatre appliqu\u00e9e dans des sc\u00e9narios concrets pour simplifier le traitement des nombres hexad\u00e9cimaux, fr\u00e9quents dans de nombreux secteurs techniques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Convertit un nombre hexad\u00e9Cimal en nombre d\u00e9Cimal<\/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-6577","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction HEX2DEC (HEXDEC) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction HEX2DEC (HEXDEC) 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\/hex2dec\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction HEX2DEC (HEXDEC) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction HEX2DEC (HEXDEC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/hex2dec\/\" \/>\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:07:21+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction HEX2DEC (HEXDEC) 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\/hex2dec\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/hex2dec\/\",\"name\":\"Fonction HEX2DEC (HEXDEC) 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:07:21+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction HEX2DEC (HEXDEC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/hex2dec\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/hex2dec\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/hex2dec\/#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\":\"HEXDEC\"}]},{\"@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 HEX2DEC (HEXDEC) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction HEX2DEC (HEXDEC) 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\/hex2dec\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction HEX2DEC (HEXDEC) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction HEX2DEC (HEXDEC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/hex2dec\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:21+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction HEX2DEC (HEXDEC) 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\/hex2dec\/","url":"https:\/\/functiontranslator.com\/fr\/hex2dec\/","name":"Fonction HEX2DEC (HEXDEC) 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:07:21+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction HEX2DEC (HEXDEC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/hex2dec\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/hex2dec\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/hex2dec\/#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":"HEXDEC"}]},{"@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\/6577","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=6577"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6577\/revisions"}],"predecessor-version":[{"id":29588,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6577\/revisions\/29588"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}