{"id":593,"date":"2023-10-14T00:25:02","date_gmt":"2023-10-14T00:25:02","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=593"},"modified":"2023-10-14T00:26:47","modified_gmt":"2023-10-14T00:26:47","slug":"funcao-formatcurrency-no-vba","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/","title":{"rendered":"FormatCurrency"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"593\" class=\"elementor elementor-593\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dfaff3 elementor-widget elementor-widget-heading\" data-id=\"2dfaff3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o FormatCurrency em VBA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2f51315 e-flex e-con-boxed e-con e-parent\" data-id=\"2f51315\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4fa0a elementor-widget elementor-widget-text-editor\" data-id=\"7f4fa0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Descri\u00e7\u00e3o:<\/h2>\n<p>A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.<br>Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.<br>Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.<br>Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.<br><span style=\"font-size: 2.6rem; font-weight: 700; color: var( --e-global-color-text ); text-align: var(--text-align);\">Exemplos:<\/span><\/p>\n<pre><code>\nSub Exemplo1()\n    Dim valor As Double\n    valor = 1234.56\n    \n    Dim valorFormatado As String\n    valorFormatado = FormatCurrency(valor)\n    \n    MsgBox \"O valor formatado \u00e9: \" &amp; valorFormatado\nEnd Sub\n    <\/code><\/pre>\n<p>Neste exemplo, a fun\u00e7\u00e3o <code>FormatCurrency<\/code> \u00e9 utilizada para formatar o valor 1234.56 como uma string de moeda.<\/p>\n<pre><code>\nSub Exemplo2()\n    Dim valor As Double\n    valor = 789.01\n    \n    Dim valorFormatado As String\n    valorFormatado = FormatCurrency(valor, 2)\n    \n    MsgBox \"O valor formatado \u00e9: \" &amp; valorFormatado\nEnd Sub\n    <\/code><\/pre>\n<p>Neste exemplo, a fun\u00e7\u00e3o <code>FormatCurrency<\/code> \u00e9 utilizada para formatar o valor 789.01 como uma string de moeda com 2 casas decimais.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-731515c e-flex e-con-boxed e-con e-parent\" data-id=\"731515c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c340885 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c340885\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-doevents-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DoEvents em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-fileattr-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-times\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o FileAttr em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-dataadd-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataAdd em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-format-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-flushed\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Format em VBA - Formatar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-datepart-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataDiff em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-dateserial-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataSerial em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o FormatCurrency em VBA Descri\u00e7\u00e3o: A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">FormatCurrency<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[45],"tags":[27,30,31,32,34,35,36,38,39,40,41,42,43,44,37,29,28,7,11],"class_list":["post-593","post","type-post","status-publish","format-standard","hentry","category-funcoes-de-formatar","tag-conversao-de-texto-para-numero","tag-curdir","tag-data","tag-dateadd","tag-datediff","tag-datepart","tag-dateserial","tag-day","tag-doevents","tag-eof","tag-error","tag-fileattr","tag-filedatetime","tag-filelen","tag-funcao-day","tag-funcao-val","tag-val","tag-vba","tag-visual-basic-for-applications"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>FormatCurrency - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FormatCurrency - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-14T00:25:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-14T00:26:47+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/\",\"name\":\"FormatCurrency - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-10-14T00:25:02+00:00\",\"dateModified\":\"2023-10-14T00:26:47+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FormatCurrency\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FormatCurrency - Saibam","description":"A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.","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:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/","og_locale":"pt_PT","og_type":"article","og_title":"FormatCurrency - Saibam","og_description":"A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.","og_url":"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/","og_site_name":"Saibam","article_published_time":"2023-10-14T00:25:02+00:00","article_modified_time":"2023-10-14T00:26:47+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/","url":"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/","name":"FormatCurrency - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-10-14T00:25:02+00:00","dateModified":"2023-10-14T00:26:47+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o FormatCurrency em VBA \u00e9 uma ferramenta essencial para a formata\u00e7\u00e3o de valores como moeda. Ela permite que os desenvolvedores apliquem configura\u00e7\u00f5es de formata\u00e7\u00e3o espec\u00edficas de moeda ao exibir ou manipular valores financeiros em suas macros do Excel. Isso \u00e9 especialmente \u00fatil em situa\u00e7\u00f5es onde \u00e9 necess\u00e1rio apresentar valores monet\u00e1rios de forma clara e leg\u00edvel para os usu\u00e1rios.Essa fun\u00e7\u00e3o oferece a flexibilidade de controlar o n\u00famero de casas decimais exibidas, bem como o s\u00edmbolo da moeda e o estilo de separador de milhares, de acordo com as prefer\u00eancias locais do usu\u00e1rio.Ao utilizar a fun\u00e7\u00e3o FormatCurrency, os desenvolvedores podem garantir uma representa\u00e7\u00e3o visualmente consistente e profissional de valores monet\u00e1rios em suas aplica\u00e7\u00f5es VBA, proporcionando uma experi\u00eancia mais agrad\u00e1vel para os usu\u00e1rios finais.Em resumo, a fun\u00e7\u00e3o FormatCurrency \u00e9 uma ferramenta valiosa para qualquer programador VBA que trabalha com manipula\u00e7\u00e3o de valores financeiros e deseja apresent\u00e1-los de forma clara e formatada.","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/funcao-formatcurrency-no-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"FormatCurrency"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Outubro 14, 2023","get_modified_date":"Outubro 14, 2023","category_list":{"category":[{"term_id":45,"name":"Fun\u00e7\u00f5es de Formatar","slug":"funcoes-de-formatar","term_group":0,"term_taxonomy_id":45,"taxonomy":"category","description":"","parent":0,"count":5,"filter":"raw"}],"post_tag":[{"term_id":27,"name":"Convers\u00e3o de Texto para N\u00famero","slug":"conversao-de-texto-para-numero","term_group":0,"term_taxonomy_id":27,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":30,"name":"CurDir","slug":"curdir","term_group":0,"term_taxonomy_id":30,"taxonomy":"post_tag","description":"","parent":0,"count":122,"filter":"raw"},{"term_id":31,"name":"data","slug":"data","term_group":0,"term_taxonomy_id":31,"taxonomy":"post_tag","description":"","parent":0,"count":121,"filter":"raw"},{"term_id":32,"name":"dateadd","slug":"dateadd","term_group":0,"term_taxonomy_id":32,"taxonomy":"post_tag","description":"","parent":0,"count":120,"filter":"raw"},{"term_id":34,"name":"datediff","slug":"datediff","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":119,"filter":"raw"},{"term_id":35,"name":"DatePart","slug":"datepart","term_group":0,"term_taxonomy_id":35,"taxonomy":"post_tag","description":"","parent":0,"count":118,"filter":"raw"},{"term_id":36,"name":"dateserial","slug":"dateserial","term_group":0,"term_taxonomy_id":36,"taxonomy":"post_tag","description":"","parent":0,"count":117,"filter":"raw"},{"term_id":38,"name":"day","slug":"day","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":39,"name":"doevents","slug":"doevents","term_group":0,"term_taxonomy_id":39,"taxonomy":"post_tag","description":"","parent":0,"count":113,"filter":"raw"},{"term_id":40,"name":"EOF","slug":"eof","term_group":0,"term_taxonomy_id":40,"taxonomy":"post_tag","description":"","parent":0,"count":111,"filter":"raw"},{"term_id":41,"name":"error","slug":"error","term_group":0,"term_taxonomy_id":41,"taxonomy":"post_tag","description":"","parent":0,"count":110,"filter":"raw"},{"term_id":42,"name":"FileAttr","slug":"fileattr","term_group":0,"term_taxonomy_id":42,"taxonomy":"post_tag","description":"","parent":0,"count":109,"filter":"raw"},{"term_id":43,"name":"FileDateTime","slug":"filedatetime","term_group":0,"term_taxonomy_id":43,"taxonomy":"post_tag","description":"","parent":0,"count":108,"filter":"raw"},{"term_id":44,"name":"FileLen","slug":"filelen","term_group":0,"term_taxonomy_id":44,"taxonomy":"post_tag","description":"","parent":0,"count":107,"filter":"raw"},{"term_id":37,"name":"fun\u00e7\u00e3o day","slug":"funcao-day","term_group":0,"term_taxonomy_id":37,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":29,"name":"Fun\u00e7\u00e3o Val","slug":"funcao-val","term_group":0,"term_taxonomy_id":29,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":28,"name":"Val","slug":"val","term_group":0,"term_taxonomy_id":28,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":7,"name":"VBA","slug":"vba","term_group":0,"term_taxonomy_id":7,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":11,"name":"Visual Basic for Applications","slug":"visual-basic-for-applications","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/funcoes-de-formatar\/\" alt=\"Fun\u00e7\u00f5es de Formatar\" class=\"category-funcoes-de-formatar\">Fun\u00e7\u00f5es de Formatar<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/conversao-de-texto-para-numero\/\" alt=\"Convers\u00e3o de Texto para N\u00famero\" class=\"post_tag-conversao-de-texto-para-numero\">Convers\u00e3o de Texto para N\u00famero<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/curdir\/\" alt=\"CurDir\" class=\"post_tag-curdir\">CurDir<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/data\/\" alt=\"data\" class=\"post_tag-data\">data<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateadd\/\" alt=\"dateadd\" class=\"post_tag-dateadd\">dateadd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datediff\/\" alt=\"datediff\" class=\"post_tag-datediff\">datediff<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datepart\/\" alt=\"DatePart\" class=\"post_tag-datepart\">DatePart<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateserial\/\" alt=\"dateserial\" class=\"post_tag-dateserial\">dateserial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/day\/\" alt=\"day\" class=\"post_tag-day\">day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/doevents\/\" alt=\"doevents\" class=\"post_tag-doevents\">doevents<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/eof\/\" alt=\"EOF\" class=\"post_tag-eof\">EOF<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/error\/\" alt=\"error\" class=\"post_tag-error\">error<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/fileattr\/\" alt=\"FileAttr\" class=\"post_tag-fileattr\">FileAttr<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filedatetime\/\" alt=\"FileDateTime\" class=\"post_tag-filedatetime\">FileDateTime<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/filelen\/\" alt=\"FileLen\" class=\"post_tag-filelen\">FileLen<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-day\/\" alt=\"fun\u00e7\u00e3o day\" class=\"post_tag-funcao-day\">fun\u00e7\u00e3o day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-val\/\" alt=\"Fun\u00e7\u00e3o Val\" class=\"post_tag-funcao-val\">Fun\u00e7\u00e3o Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/val\/\" alt=\"Val\" class=\"post_tag-val\">Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vba\/\" alt=\"VBA\" class=\"post_tag-vba\">VBA<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/visual-basic-for-applications\/\" alt=\"Visual Basic for Applications\" class=\"post_tag-visual-basic-for-applications\">Visual Basic for Applications<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=593"}],"version-history":[{"count":5,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/593\/revisions"}],"predecessor-version":[{"id":598,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/593\/revisions\/598"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}