![]() |
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