http://blogs.technet.com/b/heyscriptingguy/archive/2007/02/19/how-can-i-specify-the-number-of-decimal-places-to-display-in-an-excel-spreadsheet.aspxHey, Scripting Guy! How can I specify the number of decimal places to be displayed in an Excel spreadsheet? -- JS Hey, JS. Yes, it is Presidents Day here in the US, a day on which schools, banks, and government offices are all closed. Fortunately,en-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/heyscriptingguy/archive/2007/02/19/how-can-i-specify-the-number-of-decimal-places-to-display-in-an-excel-spreadsheet.aspx#3391721Fri, 04 Mar 2011 08:28:23 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3391721Markus Hahn<p>Me again. I forgot to mention that I want to do that in PowerShell.</p> <p>Regards</p> <p>Markus</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3391721" width="1" height="1">http://blogs.technet.com/b/heyscriptingguy/archive/2007/02/19/how-can-i-specify-the-number-of-decimal-places-to-display-in-an-excel-spreadsheet.aspx#3391720Fri, 04 Mar 2011 08:22:35 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3391720Markus Hahn<p>Hi Scripting guy,</p> <p>but how would I do that for an entire column ? Let&#39;s say column E. I would like to format that column to numeric with two decimal places and activated 1000 separator.</p> <p>Regards</p> <p>Markus</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3391720" width="1" height="1">