{"id":6370,"date":"2016-01-01T18:13:59","date_gmt":"2016-01-01T17:13:59","guid":{"rendered":"http:\/\/www.auditsi.eu\/?p=6370"},"modified":"2016-01-01T18:13:59","modified_gmt":"2016-01-01T17:13:59","slug":"excel-vba-formater-laffichage-des-nombres","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=6370","title":{"rendered":"EXCEL, VBA : formater l&#8217;affichage des nombres"},"content":{"rendered":"<p style=\"text-align: justify;\">Le formatage de l&#8217;affichage des donn\u00e9es chiffr\u00e9es dans Excel facilite leur lecture. Ce formatage s&#8217;op\u00e8re \u00e0 partir du ruban de menus ainsi qu&#8217;\u00e0 partir du menu contextuel (clic droit dans une cellule ou une plage de cellules).<\/p>\n<div id=\"attachment_6371\" style=\"width: 578px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.auditsi.eu\/?attachment_id=6371\" rel=\"attachment wp-att-6371\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6371\" class=\"size-full wp-image-6371\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/01\/EXCEL-Format-cellule.png\" alt=\"EXCEL - Format cellule\" width=\"568\" height=\"458\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/01\/EXCEL-Format-cellule.png 568w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2016\/01\/EXCEL-Format-cellule-300x242.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/a><p id=\"caption-attachment-6371\" class=\"wp-caption-text\">EXCEL &#8211; Format cellule<\/p><\/div>\n<p style=\"text-align: justify;\">En VBA, le formatage des nombres\u00a0est command\u00e9\u00a0\u00e0 l&#8217;aide de l&#8217;instruction <em>.NumberFormat<\/em> appliqu\u00e9e \u00e0 <em>.Cells<\/em> ou <em>.Range<\/em> :<\/p>\n<pre class=\"lang:default decode:true\">With .Cells(Ligned\u00e9butEch\u00e9ances + NumEch\u00e9ancier - 1, 13)\r\n    .Value = Intplus5ans\r\n    .NumberFormat = \"#,##0.00\"\r\nEnd With<\/pre>\n<p>Les deux formats num\u00e9riques les plus courants, s\u00e9parateur de milliers avec deux d\u00e9cimales et pourcentage, se param\u00e8trent respectivement ainsi : &#8220;#,##0.00&#8221; et &#8220;#,##0.00%&#8221; ; par exemple, pour les pourcentages :<\/p>\n<pre class=\"lang:default decode:true \">.NumberFormat = \"#,##0.00%\"<\/pre>\n<p>Approfondir le sujet : <a title=\"Programmer en VBA\" href=\"http:\/\/www.auditsi.eu\/?cat=1569\">Programmer en VBA<\/a> \/ <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%2C%20VBA%20%3A%20formater%20l%27affichage%20des%20nombres\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Le formatage de l&#8217;affichage des donn\u00e9es chiffr\u00e9es dans Excel facilite leur lecture. Ce formatage s&#8217;op\u00e8re \u00e0 partir du ruban de menus ainsi qu&#8217;\u00e0 partir du menu contextuel (clic droit dans une cellule ou une plage de cellules). En VBA, le formatage des nombres\u00a0est command\u00e9\u00a0\u00e0 l&#8217;aide de l&#8217;instruction .NumberFormat appliqu\u00e9e \u00e0 .Cells ou .Range : With &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=6370\" class=\"more-link\">Continue reading &lsquo;EXCEL, VBA : formater l&#8217;affichage des nombres&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%2C%20VBA%20%3A%20formater%20l%27affichage%20des%20nombres\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[7,1569,215],"tags":[1660,249,927,1633,1663,1561,1661,263,1662,1641],"class_list":["post-6370","post","type-post","status-publish","format-standard","hentry","category-breves","category-programmer-en-vba","category-vba","tag-numberformat","tag-cells","tag-decimales","tag-excel","tag-formatage","tag-plage-de-cellules","tag-pourcentage","tag-range","tag-separateur-de-milliers","tag-vba"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6370"}],"version-history":[{"count":2,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6370\/revisions"}],"predecessor-version":[{"id":6373,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/6370\/revisions\/6373"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}