{"id":10925,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/hexaoct\/"},"modified":"2021-02-25T17:20:48","modified_gmt":"2021-02-25T17:20:48","slug":"hex2oct","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/","title":{"rendered":"HEXAOCT"},"content":{"rendered":"

Sintaxe e Uso Geral<\/h2>\n

A fun\u00e7\u00e3o HEX2OCT<\/code> (ou HEXAOCT<\/code> em algumas localiza\u00e7\u00f5es) tem como objetivo converter um n\u00famero hexadecimal em um n\u00famero octal. Essa fun\u00e7\u00e3o \u00e9 suportada tanto pelo Microsoft Excel quanto pelo Google Planilhas, sendo amplamente aplicada em diversas \u00e1reas da engenharia e inform\u00e1tica.<\/p>\n

Sintaxe no Excel e Google Planilhas<\/h3>\n
HEX2OCT(n\u00famero_hex; [casas])<\/code><\/pre>\n
    \n
  • n\u00famero_hex<\/strong>: O n\u00famero em formato hexadecimal que ser\u00e1 convertido para octal. Este deve ser inserido como uma string.<\/li>\n
  • casas<\/strong>: (Opcional) Define o n\u00famero de d\u00edgitos do resultado. Caso o resultado possua menos d\u00edgitos do que o especificado, zeros ser\u00e3o adicionados \u00e0 esquerda at\u00e9 alcan\u00e7ar o comprimento desejado.<\/li>\n<\/ul>\n
    Exemplos Pr\u00e1ticos<\/h2>\n
    Veja a seguir exemplos de como essa fun\u00e7\u00e3o pode ser empregada.<\/p>\n
    Exemplo 1: Convers\u00e3o Simples<\/h3>\n
    Convers\u00e3o do n\u00famero hexadecimal ‘1A3’ para octal.<\/p>\n
    =HEX2OCT(\"1A3\")<\/code><\/pre>\n
      \n
    • Resultado:<\/strong> 503<\/li>\n<\/ul>\n
      Este resultado representa o valor ‘1A3’ em hexadecimal convertido para a base octal.<\/p>\n
      Exemplo 2: Convers\u00e3o com N\u00famero Definido de D\u00edgitos<\/h3>\n
      Para assegurar uniformidade em documentos ou sistemas que exigem um padr\u00e3o fixo de d\u00edgitos, \u00e9 poss\u00edvel especificar o n\u00famero de d\u00edgitos do resultado.<\/p>\n
      =HEX2OCT(\"1A3\", 5)<\/code><\/pre>\n
        \n
      • Resultado:<\/strong> 00503<\/li>\n<\/ul>\n
        Neste caso, dois zeros s\u00e3o adicionados antes do n\u00famero octal para que o resultado contenha exatamente 5 d\u00edgitos.<\/p>\n
        Usos Pr\u00e1ticos da Fun\u00e7\u00e3o<\/h2>\n
        Compreender as aplica\u00e7\u00f5es pr\u00e1ticas de uma fun\u00e7\u00e3o \u00e9 essencial para aproveitar ao m\u00e1ximo suas capacidades.<\/p>\n
        \u00c2mbito da Eletr\u00f4nica e da Computa\u00e7\u00e3o<\/h3>\n
        Em eletr\u00f4nica e ci\u00eancias da computa\u00e7\u00e3o, a representa\u00e7\u00e3o de n\u00fameros em diferentes bases num\u00e9ricas \u00e9 comum. A convers\u00e3o de hexadecimal para octal pode ser necess\u00e1ria em atividades como desenvolvimento de software para sistemas embarcados ou na elabora\u00e7\u00e3o de documenta\u00e7\u00f5es t\u00e9cnicas de circuitos.<\/p>\n
        Formata\u00e7\u00e3o para Exibi\u00e7\u00e3o Consistente<\/h3>\n
        Em ambientes de relat\u00f3rios, onde \u00e9 preciso manter um formato espec\u00edfico de apresenta\u00e7\u00e3o dos dados, a fun\u00e7\u00e3o HEX2OCT<\/code> garante que todos os n\u00fameros octais apresentem o mesmo n\u00famero de d\u00edgitos, melhorando a legibilidade e uniformizando os dados exibidos.<\/p>\n\n\n\n\n
        Entrada Hexadecimal<\/th>\nResultado Octal<\/th>\n<\/tr>\n
        1A3<\/td>\n00503<\/td>\n<\/tr>\n
        FF<\/td>\n00377<\/td>\n<\/tr>\n<\/table>\n
        Como ilustrado acima, o uso de HEX2OCT<\/code> vai al\u00e9m das simples convers\u00f5es num\u00e9ricas, integrando-se a solu\u00e7\u00f5es mais abrangentes em ambientes profissionais e t\u00e9cnicos.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Converte um n\u00famero hexadecimal em octal<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[],"class_list":["post-10925","post","type-post","status-publish","format-standard","hentry","category-engenharia"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2OCT (HEXAOCT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/hex2oct\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2OCT (HEXAOCT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:20:48+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/\",\"name\":\"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:20:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2OCT (HEXAOCT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Engenharia\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/engenharia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HEXAOCT\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2OCT (HEXAOCT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/hex2oct\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2OCT (HEXAOCT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:20:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/","url":"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/","name":"Fun\u00e7\u00e3o HEX2OCT (HEXAOCT) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:20:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2OCT (HEXAOCT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/hex2oct\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Engenharia","item":"https:\/\/functiontranslator.com\/pt-pt\/engenharia\/"},{"@type":"ListItem","position":3,"name":"HEXAOCT"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10925"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10925\/revisions"}],"predecessor-version":[{"id":25754,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10925\/revisions\/25754"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}