Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Cells - Currency v. Accounting Laya Setting up and Configuration of Excel 1 March 11th 10 01:29 PM
How to format cells in Excel 2007 (i.e. currency format)? DonR Excel Discussion (Misc queries) 2 May 25th 08 11:16 PM
Formating excel value to numeric or currency with interop Tim Lypes Excel Programming 0 July 7th 06 05:10 PM
format cells for currency 2450 and have it format to $24.50? Karen C Excel Worksheet Functions 0 October 13th 05 03:21 PM
Setting range of cells format to currency Radek Michalski Excel Programming 1 December 20th 03 11:15 PM


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"