Macro can't change currency symbol

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Flanagan - 17 May 2008 12:31 GMT

This is a strange one. I have a person in the UK who can manually change
the format of cell from Euro's to $'s. But, if we record the macro to do
that same action and run it on other cells (or the original cell after doing
an undo), it changes the format from Euro's to British pounds. The code in
the macro is just one line, the recorded new cell format.

Any ideas?

Bob

Reply to this Message

Gary''s Student - 17 May 2008 15:08 GMT

Post the line.

Signature

Gary''s Student - gsnu200786

Reply to this Message

Mais qui est Paul - 17 May 2008 18:12 GMT

Bonsour® Bob Flanagan avec ferveur ;o))) vous nous disiez :

> This is a strange one. I have a person in the UK who can manually
> change the format of cell from Euro's to $'s. But, if we record the
[quoted text clipped - 3 lines]
> recorded new cell format.
> Any ideas?

Sub Macro1()
Selection.NumberFormat = "[$£-809]#,##0.00"
MsgBox "selected is now Pound United kingdom"
Selection.NumberFormat = "[$$-409]#,##0.00"
MsgBox "selected is now selected US Dollar"
Selection.NumberFormat = "#,##0.00 [$CAD]"
MsgBox "selected is now Canandian Dollar"
End Sub

HTH

Signature

@+
;o)))

Reply to this Message

Bob Flanagan - 17 May 2008 22:46 GMT

Many thanks. I will give it a try. Any idea why the $ sign is needed in of
each, especially the double $$ for US$'s?

Bob

> Bonsour® Bob Flanagan avec ferveur ;o))) vous nous disiez :
>
[quoted text clipped - 15 lines]
>
> HTH

Reply to this Message