{"id":497,"date":"2023-10-26T09:02:13","date_gmt":"2023-10-26T09:02:13","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/"},"modified":"2023-12-25T10:30:28","modified_gmt":"2023-12-25T10:30:28","slug":"formatoporcentaje","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1252541593\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>La funci\u00f3n VBA FORMATPERCENT figura en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve la expresi\u00f3n proporcionada aplic\u00e1ndole un formato de porcentaje<\/strong> . En palabras simples, devuelve el resultado con formato de porcentaje como tipo de datos de cadena.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>FormatPercent(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [GroupDigits])<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Expresi\u00f3n<\/strong> : La expresi\u00f3n que desea formatear.<\/li>\n<li> <strong>[<\/strong> <strong>NumDigitsAfterDecimal]<\/strong> : un valor num\u00e9rico para especificar lugares decimales [Este es un argumento opcional y, si se omite, el valor predeterminado es -1].<\/li>\n<li> <strong>[IncludeLeadingDigit]<\/strong> : un valor de enumeraci\u00f3n para especificar si se debe mostrar un cero a la izquierda [Este es un argumento opcional y, si se omite, VBA usar\u00e1 vbUseDefault de forma predeterminada].\n<ul>\n<li> vbFalse: no debe ir precedido de un cero.<\/li>\n<li> vbTrue: muestra un cero a la izquierda.<\/li>\n<li> vbUseDefault: utiliza la configuraci\u00f3n predeterminada.<\/li>\n<\/ul>\n<\/li>\n<li> <strong>[UseParensForNegativeNumbers]<\/strong> : un valor de enumeraci\u00f3n para especificar si los n\u00fameros negativos deben incluirse entre par\u00e9ntesis [Este es un argumento opcional y, si se omite, VBA usar\u00e1 vbUseDefault de forma predeterminada].\n<ul>\n<li> vbFalse: no poner n\u00fameros negativos entre par\u00e9ntesis.<\/li>\n<li> vbTrue: coloca n\u00fameros negativos entre par\u00e9ntesis.<\/li>\n<li> vbUseDefault: utiliza la configuraci\u00f3n predeterminada.<\/li>\n<\/ul>\n<\/li>\n<li> <strong>[GroupDigits]<\/strong> : un valor de enumeraci\u00f3n para especificar si el n\u00famero debe agruparse (en miles, etc.), utilizando el delimitador de grupo especificado en la configuraci\u00f3n regional de la computadora [Este es un argumento opcional y si se omite, VBA tomar\u00e1 vbUseDefault de forma predeterminada ].\n<ul>\n<li> vbFalse: no utilizar los n\u00fameros del grupo.<\/li>\n<li> vbTrue: para utilizar los n\u00fameros del grupo.<\/li>\n<li> vbUseDefault: utiliza la configuraci\u00f3n predeterminada de la computadora.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA FORMATPERCENT, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-funci\u00f3n-porcentaje-formato-vba\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-formatpercent-function\" width=\"840\" height=\"465\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_FORMATPERCENT() Range(\"B1\").Value = FormatPercent(Range(\"A1\")) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos FORMATPERCENT para convertir el valor de la celda A1 en porcentaje y devolvimos el resultado en la celda B1.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el valor especificado es un valor distinto de un n\u00famero o una cadena que no puede reconocerse como un n\u00famero, VBA devolver\u00e1 el error de ejecuci\u00f3n 13. <\/li>\n<\/ul>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-256\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/booleano\/\">VBA CBOOL<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cbyte\/\">Bytes VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ocurre\/\">VBA CCUR<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-c\/\">CDATE VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cdbl\/\">VBA CDBL<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA FORMATPERCENT figura en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la expresi\u00f3n proporcionada aplic\u00e1ndole un formato de porcentaje . En palabras simples, devuelve el resultado con formato de porcentaje como tipo de datos de cadena. Sintaxis FormatPercent(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [GroupDigits]) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-497","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA FORMATPERCENT figura en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la expresi\u00f3n proporcionada aplic\u00e1ndole un formato de porcentaje . En palabras simples, devuelve el resultado con formato de porcentaje como tipo de datos de cadena. Sintaxis FormatPercent(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [GroupDigits]) [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png\",\"datePublished\":\"2023-10-26T09:02:13+00:00\",\"dateModified\":\"2023-12-25T10:30:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?","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:\/\/exceladvisor.org\/es\/formatoporcentaje\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?","og_description":"La funci\u00f3n VBA FORMATPERCENT figura en la categor\u00eda de conversi\u00f3n de tipo de datos de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve la expresi\u00f3n proporcionada aplic\u00e1ndole un formato de porcentaje . En palabras simples, devuelve el resultado con formato de porcentaje como tipo de datos de cadena. Sintaxis FormatPercent(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [GroupDigits]) [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/","url":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png","datePublished":"2023-10-26T09:02:13+00:00","dateModified":"2023-12-25T10:30:28+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/formatoporcentaje\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatpercent.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/formatoporcentaje\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba formatpercent?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=497"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/497\/revisions"}],"predecessor-version":[{"id":1270,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/497\/revisions\/1270"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}