{"id":496,"date":"2023-10-26T09:17:37","date_gmt":"2023-10-26T09:17:37","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/"},"modified":"2023-12-25T10:28:28","modified_gmt":"2023-12-25T10:28:28","slug":"numero-de-formato","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n formatnumber de vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3760408723\"><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 FORMATNUMBER aparece 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 num\u00e9rico<\/strong> . En t\u00e9rminos simples, el resultado que obtiene tiene un formato num\u00e9rico como un tipo de datos de cadena.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>FormatNumber(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>[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, 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, el valor predeterminado es vbUseDefault).\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> : n 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, 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 FORMATNUMBER de VBA, debe seguir el siguiente ejemplo donde hemos escrito 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-vba-formato-n\u00famero-funci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-formatnumber-function\" width=\"843\" height=\"420\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_FORMATNUMBER() Range(\"B1\").Value = FormatNumber(Range(\"A1\")) End Sub<\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos FORMATNUMBER para convertir el valor de la celda A1 en un valor num\u00e9rico 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-260\">\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 FORMATNUMBER aparece 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 num\u00e9rico . En t\u00e9rminos simples, el resultado que obtiene tiene un formato num\u00e9rico como un tipo de datos de cadena. Sintaxis FormatNumber(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [&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-496","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 formatnumber de vba?<\/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\/numero-de-formato\/\" \/>\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 formatnumber de vba?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA FORMATNUMBER aparece 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 num\u00e9rico . En t\u00e9rminos simples, el resultado que obtiene tiene un formato num\u00e9rico como un tipo de datos de cadena. Sintaxis FormatNumber(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.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\/numero-de-formato\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n formatnumber de vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png\",\"datePublished\":\"2023-10-26T09:17:37+00:00\",\"dateModified\":\"2023-12-25T10:28:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n formatnumber de vba?\"}]},{\"@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 formatnumber de vba?","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\/numero-de-formato\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n formatnumber de vba?","og_description":"La funci\u00f3n VBA FORMATNUMBER aparece 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 num\u00e9rico . En t\u00e9rminos simples, el resultado que obtiene tiene un formato num\u00e9rico como un tipo de datos de cadena. Sintaxis FormatNumber(Expresi\u00f3n, [NumDigitsAfterDecimal], [IncludeLeadingDigit],[UseParensForNegativeNumbers], [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.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\/numero-de-formato\/","url":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n formatnumber de vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png","datePublished":"2023-10-26T09:17:37+00:00","dateModified":"2023-12-25T10:28:28+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/numero-de-formato\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-formatnumber.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/numero-de-formato\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n formatnumber de vba?"}]},{"@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\/496","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=496"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/496\/revisions"}],"predecessor-version":[{"id":1312,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/496\/revisions\/1312"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}