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

Description et syntaxe de la fonction<\/h2>\n

La fonction OCT2HEX dans Excel permet de convertir un nombre octal en un nombre hexad\u00e9cimal. Cette fonction est particuli\u00e8rement pr\u00e9cieuse dans les domaines de l’informatique et de l’\u00e9lectronique, o\u00f9 les conversions entre diff\u00e9rentes bases num\u00e9riques sont courantes.<\/p>\n

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

=OCT2HEX(nombre_octal; [nb_chiffres]) <\/code><\/pre>\n
    \n
  • nombre_octal<\/strong> : Le nombre en base 8 que vous souhaitez convertir en hexad\u00e9cimal. Il doit s’agir d’une cha\u00eene de caract\u00e8res qui repr\u00e9sente un nombre octal valide.<\/li>\n
  • nb_chiffres<\/strong> (facultatif) : Le nombre minimal de chiffres que le r\u00e9sultat hexad\u00e9cimal doit contenir. Des z\u00e9ros seront ajout\u00e9s \u00e0 gauche si le nombre converti comporte moins de chiffres que sp\u00e9cifi\u00e9.<\/li>\n<\/ul>\n
    Syntaxe de la fonction dans Google Sheets :<\/p>\n
    =DEC2HEX(OCT2DEC(nombre_octal); [nb_chiffres]) <\/code><\/pre>\n
    Note : Dans Google Sheets, il est n\u00e9cessaire de convertir d’abord le nombre octal en d\u00e9cimal avec la fonction OCT2DEC, puis en hexad\u00e9cimal avec DEC2HEX.<\/p>\n
    Exemples d’utilisation<\/h2>\n
    Exemple 1 : Conversion d’un nombre simple<\/p>\n
    Supposons que vous ayez le nombre octal 71<\/code>. Pour le convertir en hexad\u00e9cimal dans Excel :<\/p>\n
    =OCT2HEX(\"71\") <\/code><\/pre>\n
    Cela renvoie 39<\/code>, qui est l’\u00e9quivalent hexad\u00e9cimal du nombre octal 71<\/code>.<\/p>\n
    Exemple 2 : Conversion avec sp\u00e9cification du nombre minimal de chiffres<\/p>\n
    Pour convertir le nombre octal 71<\/code> en hexad\u00e9cimal avec au moins 4 chiffres dans le r\u00e9sultat :<\/p>\n
    =OCT2HEX(\"71\"; 4) <\/code><\/pre>\n
    Cela donne 0039<\/code>, assurant que le r\u00e9sultat comprend au moins quatre chiffres.<\/p>\n
    Sc\u00e9narios d’utilisation pratique<\/h2>\n
    Cas pratique 1 : Gestion d’un syst\u00e8me o\u00f9 les adresses en octal doivent \u00eatre converties en hexad\u00e9cimal pour le d\u00e9bogage<\/p>\n
    Description :<\/p>\n
    Un ing\u00e9nieur syst\u00e8me doit convertir des adresses m\u00e9moire de l’octal vers l’hexad\u00e9cimal pour les utiliser dans des outils de diagnostic qui n’acceptent que cette derni\u00e8re base.<\/p>\n
    Solution :<\/p>\n
      \n
    • R\u00e9colte des adresses en format octal.<\/li>\n
    • Utilisation de la formule =OCT2HEX(\"adresse_octal\")<\/code> pour chaque adresse.<\/li>\n
    • Int\u00e9gration des adresses hexad\u00e9cimales dans l’outil de d\u00e9bogage.<\/li>\n<\/ul>\n
      Le tableau ci-dessous illustre un exemple de conversion :<\/p>\n\n\n\n\n
      Adresse Octale<\/th>\nAdresse Hexad\u00e9cimale<\/th>\n<\/tr>\n
      234<\/td>\n=OCT2HEX(\u00ab\u00a0234\u00a0\u00bb) -> C4<\/td>\n<\/tr>\n
      771<\/td>\n=OCT2HEX(\u00ab\u00a0771\u00a0\u00bb) -> F9<\/td>\n<\/tr>\n<\/table>\n
      Cas pratique 2 : Conversion des permissions de fichier de Unix\/Linux<\/p>\n
      Description :<\/p>\n
      Un administrateur syst\u00e8me souhaite convertir les permissions de fichier, qui sont souvent exprim\u00e9es en format octal dans les syst\u00e8mes Unix\/Linux, en hexad\u00e9cimal pour une application sp\u00e9cifique.<\/p>\n
      Solution :<\/p>\n
        \n
      • Collecte des permissions en octal (ex. 755).<\/li>\n
      • Conversion en utilisant la commande =OCT2HEX(\"755\")<\/code>.<\/li>\n<\/ul>\n
        Le r\u00e9sultat est F5<\/code>, utilisable selon les besoins de l’application concern\u00e9e.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Convertit un nombre oCtal en nombre hexad\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-6699","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction OCT2HEX (OCTHEX) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction OCT2HEX (OCTHEX) 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\/oct2hex\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction OCT2HEX (OCTHEX) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction OCT2HEX (OCTHEX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/oct2hex\/\" \/>\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: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 OCT2HEX (OCTHEX) 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\/oct2hex\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/oct2hex\/\",\"name\":\"Fonction OCT2HEX (OCTHEX) 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:21+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction OCT2HEX (OCTHEX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/oct2hex\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/oct2hex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/oct2hex\/#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\":\"OCTHEX\"}]},{\"@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 OCT2HEX (OCTHEX) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction OCT2HEX (OCTHEX) 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\/oct2hex\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction OCT2HEX (OCTHEX) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction OCT2HEX (OCTHEX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/oct2hex\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:21+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction OCT2HEX (OCTHEX) 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\/oct2hex\/","url":"https:\/\/functiontranslator.com\/fr\/oct2hex\/","name":"Fonction OCT2HEX (OCTHEX) 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:21+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction OCT2HEX (OCTHEX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/oct2hex\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/oct2hex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/oct2hex\/#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":"OCTHEX"}]},{"@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\/6699","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=6699"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6699\/revisions"}],"predecessor-version":[{"id":29710,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6699\/revisions\/29710"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}