{"id":6507,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/devise\/"},"modified":"2021-02-26T08:05:03","modified_gmt":"2021-02-26T08:05:03","slug":"dollar","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dollar\/","title":{"rendered":"DEVISE"},"content":{"rendered":"

Introduction \u00e0 la fonction DOLLAR<\/h2>\n

La fonction DOLLAR, \u00e9galement connue sous le nom de DEVISE dans certaines versions d’Excel, sert \u00e0 transformer un nombre en texte format\u00e9 en utilisant le format mon\u00e9taire sp\u00e9cifique, incluant les d\u00e9cimales et le symbole de la devise concern\u00e9e. Elle est essentielle dans les rapports financiers pour assurer une pr\u00e9sentation claire et pr\u00e9cise des montants d’argent.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction DOLLAR dans Excel :<\/p>\n

=DOLLAR(nombre, [d\u00e9cimales])<\/code><\/pre>\n
    \n
  • nombre<\/strong> : C’est la valeur num\u00e9rique que vous souhaitez formater en monnaie.<\/li>\n
  • d\u00e9cimales (optionnel)<\/strong> : D\u00e9termine le nombre de d\u00e9cimales \u00e0 afficher. Par d\u00e9faut, il est fix\u00e9 \u00e0 2 si ce param\u00e8tre est omis.<\/li>\n<\/ul>\n
    Exemples<\/h2>\n
    Exemple 1: Formatage simple<\/p>\n
    =DOLLAR(1234.567) \/\/ R\u00e9sultat: $1,234.57<\/code><\/pre>\n
    Cet exemple illustre la conversion d’un nombre en texte format\u00e9 selon les standards mon\u00e9taires, arrondi \u00e0 deux d\u00e9cimales.<\/p>\n
    Exemple 2: Sp\u00e9cification des d\u00e9cimales<\/p>\n
    =DOLLAR(1234.567, 3) \/\/ R\u00e9sultat: $1,234.567<\/code><\/pre>\n
    Dans cet exemple, la fonction DOLLAR permet de formater le nombre en utilisant trois d\u00e9cimales, comme sp\u00e9cifi\u00e9 par l’utilisateur.<\/p>\n
    Applications pratiques<\/h2>\n
    Voici deux situations fr\u00e9quentes o\u00f9 l’usage de la fonction DOLLAR peut s’av\u00e9rer particuli\u00e8rement utile :<\/p>\n
    Sc\u00e9nario 1: Pr\u00e9paration d’un rapport financier<\/h2>\n
     Supposons que vous soyez comptable et charg\u00e9 de pr\u00e9parer un rapport sur les revenus g\u00e9n\u00e9r\u00e9s par diff\u00e9rents produits. La mise en forme financi\u00e8re appropri\u00e9e est cruciale. <\/p>\n\n\n\n\n
    Produit<\/th>\nRevenu<\/th>\nRevenu Format\u00e9<\/th>\n<\/tr>\n
    Produit A<\/td>\n1540.50<\/td>\n=DOLLAR(B2)<\/td>\n<\/tr>\n
    Produit B<\/td>\n987.654<\/td>\n=DOLLAR(B3, 2)<\/td>\n<\/tr>\n<\/table>\n
     Les cellules dans la colonne \u00ab\u00a0Revenu Format\u00e9\u00a0\u00bb utilisent la fonction DOLLAR pour convertir les chiffres en format mon\u00e9taire, augmentant ainsi la clart\u00e9 des informations financi\u00e8res du rapport. <\/p>\n
    Sc\u00e9nario 2: Conversion rapide en devises avec des macro-commandes<\/h2>\n
     Imaginons que vous ayez souvent besoin de convertir des montants en dollars pour des estimations rapides lors de r\u00e9unions. Vous pourriez cr\u00e9er une macro pour appliquer cette formule rapidement \u00e0 tout nombre s\u00e9lectionn\u00e9 dans une feuille Excel. <\/p>\n
      Sub ConvertirEnDollar() Dim Cell As Range For Each Cell In Selection Cell.Value = Application.WorksheetFunction.Text(Cell.Value, \"#,##0.00 $\") Next Cell End Sub <\/code> <\/pre>\n
     Cette macro parcourt chaque cellule s\u00e9lectionn\u00e9e et lui applique un formatage mon\u00e9taire adapt\u00e9, facilitant ainsi les conversions dynamiques et rapides pendant les discussions financi\u00e8res. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Convertit un nombre en texte en utilisant le format mon\u00e9taire \u20ac (euro)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[314],"tags":[],"class_list":["post-6507","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DOLLAR (DEVISE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/dollar\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DOLLAR (DEVISE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dollar\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:05:03+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dollar\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dollar\/\",\"name\":\"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:05:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DOLLAR (DEVISE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dollar\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dollar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dollar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Texte\",\"item\":\"https:\/\/functiontranslator.com\/fr\/texte\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DEVISE\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DOLLAR (DEVISE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/dollar\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DOLLAR (DEVISE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dollar\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/dollar\/","url":"https:\/\/functiontranslator.com\/fr\/dollar\/","name":"Fonction DOLLAR (DEVISE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:05:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DOLLAR (DEVISE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dollar\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dollar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dollar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Texte","item":"https:\/\/functiontranslator.com\/fr\/texte\/"},{"@type":"ListItem","position":3,"name":"DEVISE"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6507"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6507\/revisions"}],"predecessor-version":[{"id":29519,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6507\/revisions\/29519"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}