Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Currency display after running a macro

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Currency display after running a macro

Resolved · Low Priority · Version 2003

Reply Tue 13 Dec 2011, 22:47Delegate Ana said...

Ana has attended:
Excel VBA Intro Intermediate course

Currency display after running a macro

I have been running the VBA training file (sales macro file) created in 2003 in another pc with 2010 software. The dealer price, sales price and mark up have the £ symbol dissapear and the commision is in $. Is there any currency compatabilities between 2003 and 2010 or is it the macro written wrongly?
thanks

For upcoming training course dates see: Pricing & availability

Reply Fri 16 Dec 2011, 13:07Trainer Mark said...

RE: currency display after running a macro

Hello Ana,

There is no issue between the versions, on the file you are using I don't think we wrote the format of currency in the code. To ensure correct display you need to code the format, and not expect it to pick up the format from the current cells.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Fri 23 Dec 2011: Automatically marked as resolved.

Excel articles

· Benefits of learning about Excel charts
· How To Create A Multiple Pie Chart In Excel
· What Are Sparklines In Excel 2010?
· Do You Need To Upgrade From Excel 2003 to Excel 2007?
· How To Use The Subtotal Function In Excel

Please browse our web site to find out more about
microsoft+excel+course and other Microsoft training courses.

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips