ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Format Cells Numeric Currency VBA (https://www.excelbanter.com/excel-programming/388085-excel-format-cells-numeric-currency-vba.html)

[email protected]

Excel Format Cells Numeric Currency VBA
 
Hello,

I came across some VBA Code that formats an Excel cell, and I was
wondering if anyone can explain to me what the various symbols mean:

1) _([$£-809]#,000.0_); ([$£-809]#,000.0)

2) #,##0.0[$p]_);(#,000.0[$p]);#,000.0[$p]_); @_)

3) _([$$-409]#,000.0_); ([$$-409]#,000.0)

4) [$P-1404]#,#00.0

In particular, the [$£-809] , [$p] , [$$-409] , [$P-1404]

Are there any good Web Sites that explain all this formatting?

Thanks.



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com