98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Currency Formatting
Currency Formatting
Resolved · Low Priority · Version 2003
Fri 12 Dec 2008, 15:57Delegate 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:54Trainer 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.docMon 12 Jan 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Charts with One keystrokeCreate a graph with one click |
