Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Currency Formatting

Currency Formatting

ResolvedVersion 2003

Fri 12 Dec 2008, 15:57 Delegate Erin said...

Erin has attended:
Excel VBA Intro Intermediate course

Currency Formatting

When writing code, how do you specify figures in dollars (or other currencies) as opposed to the default of

Mon 5 Jan 2009, 14:54 Trainer Stephen said...

RE: Currency Formatting

Hi Erin

Thank you for your question

To accomplish this you set the number format property of the selection .

I have added the line of code to a text file and uploaded it as the forum converts the currency symbol(for Yen) into its asciii code

The trick is to enter thedollar symbol, followed by the Yen symbol.

Regards

Stephen

Attached files...

CurrencyFormatting.doc

Mon 12 Jan 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Currency Formatting

Currency Formatting

RE: Currency Formatting

Attached files...

Excel articles

Excel tip:

Bracketed negative numbers