Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Cells - Currency v. Accounting | Setting up and Configuration of Excel | |||
How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
Formating excel value to numeric or currency with interop | Excel Programming | |||
format cells for currency 2450 and have it format to $24.50? | Excel Worksheet Functions | |||
Setting range of cells format to currency | Excel Programming |