{"id":493,"date":"2023-10-26T09:48:07","date_gmt":"2023-10-26T09:48:07","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/formato\/"},"modified":"2023-12-25T10:28:29","modified_gmt":"2023-12-25T10:28:29","slug":"formato","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/formato\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n formato vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-60705055\"><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 class=\"content-box-grey\">La funci\u00f3n VBA FORMAT aparece en la categor\u00eda de texto de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve un valor<\/strong> formateado en el formato que especific\u00f3. En pocas palabras, puede usarlo para formatear una expresi\u00f3n en un formato que pueda especificar. Hay una cosa que debes tener en cuenta aqu\u00ed: el resultado que devuelve es el tipo de datos de cadena.<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>Formato(Expresi\u00f3n,[Formato],[PrimerD\u00edaSemana],[PrimeraSemanaA\u00f1o])<\/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>[Formato]<\/strong> : El formato que desea aplicar a la expresi\u00f3n [Este es un argumento opcional y, si se omite, VBA toma General de forma predeterminada].<\/li>\n<li> <strong>[FirstDayOfWeek]<\/strong> : una cadena para definir el primer d\u00eda de la semana [Este es un argumento opcional y, si se omite, vbSunday de forma predeterminada].\n<ul>\n<li> vbUseSystemDayOfWeek: seg\u00fan la configuraci\u00f3n del sistema.<\/li>\n<li> vbDomingo \u2013 Domingo<\/li>\n<li> vblunday \u2013 lunes<\/li>\n<li> vbMartes \u2013 Martes<\/li>\n<li> vbMi\u00e9rcoles \u2013 Mi\u00e9rcoles<\/li>\n<li> vbjueves \u2013 jueves<\/li>\n<li> vbviernes \u2013 viernes<\/li>\n<li> vbs\u00e1bado \u2013 s\u00e1bado<\/li>\n<\/ul>\n<\/li>\n<li> <strong>[FirstWeekOfYear]<\/strong> : una cadena para definir la primera semana del a\u00f1o [Este es un argumento opcional y, si se omite, vbFirstJan1 de forma predeterminada].\n<ul>\n<li> vbSystem: dependiendo de la configuraci\u00f3n del sistema.<\/li>\n<li> vbFirstJan1: la semana en la que ocurre el 1 de enero.<\/li>\n<li> vbFirstFourDays: la primera semana que contiene al menos cuatro d\u00edas en el nuevo a\u00f1o.<\/li>\n<li> vbFirstFullWeek: la primera semana completa del nuevo a\u00f1o.<\/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 FORMATO VBA, 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-vba-formato\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-format-function\" width=\"824\" height=\"423\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_FORMAT() Range(\"B1\").Value = Format(Range(\"A1\"), \"Currency\") Range(\"B2\").Value = Format(Range(\"A2\"), \"Long Date\") Range(\"B3\").Value = Format(Range(\"A3\"), \"True\/False\") End Sub<\/code><\/pre>\n<p> En el ejemplo anterior, utilizamos FORMATO con tres formatos predefinidos diferentes:<\/p>\n<ol>\n<li> Convirtiendo el valor de la celda A1 al formato de moneda.<\/li>\n<li> Convirtiendo la fecha en la celda A2 a una fecha larga.<\/li>\n<li> Convirtiendo el n\u00famero de la celda A3 a booleano.<\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Tambi\u00e9n puede crear su propio formato para utilizarlo en el argumento \u00abformato\u00bb. <\/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-272\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/bien\/\">VBA DERECHO<\/a><\/li>\n<li> VBA RTRIM<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/espacio\/\">ESPACIO VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/strcomp\/\">VBA STRCOMP<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/strconv\/\">VBA STRCONV<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA FORMAT aparece en la categor\u00eda de texto de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un valor formateado en el formato que especific\u00f3. En pocas palabras, puede usarlo para formatear una expresi\u00f3n en un formato que pueda especificar. Hay una cosa que debes tener en cuenta aqu\u00ed: el resultado [&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-493","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 formato 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\/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 formato vba?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA FORMAT aparece en la categor\u00eda de texto de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un valor formateado en el formato que especific\u00f3. En pocas palabras, puede usarlo para formatear una expresi\u00f3n en un formato que pueda especificar. Hay una cosa que debes tener en cuenta aqu\u00ed: el resultado [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/formato\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:28:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.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\/formato\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/formato\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n formato vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formato\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formato\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\",\"datePublished\":\"2023-10-26T09:48:07+00:00\",\"dateModified\":\"2023-12-25T10:28:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/formato\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/formato\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/formato\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/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 formato 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 formato 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\/formato\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n formato vba?","og_description":"La funci\u00f3n VBA FORMAT aparece en la categor\u00eda de texto de las funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un valor formateado en el formato que especific\u00f3. En pocas palabras, puede usarlo para formatear una expresi\u00f3n en un formato que pueda especificar. Hay una cosa que debes tener en cuenta aqu\u00ed: el resultado [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/formato\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:28:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.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\/formato\/","url":"https:\/\/exceladvisor.org\/es\/formato\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n formato vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/formato\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/formato\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png","datePublished":"2023-10-26T09:48:07+00:00","dateModified":"2023-12-25T10:28:29+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/formato\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/formato\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/formato\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/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 formato 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\/493","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=493"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/493\/revisions"}],"predecessor-version":[{"id":1314,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/493\/revisions\/1314"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}