Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Currency Formatting
|
|
|
The UK's most regular 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. |
Currency Formatting
Resolved · Low Priority · Version 2003
Reply 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
For upcoming training course dates see: Pricing & availability
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.
|