Using Excel 2003
I have a line in a VBA code because when I enter a '$' sign, the '‚¬' sign
is returned.
(If Target.Value = "$" Then Range("B1").NumberFormat = "$" & "0.00")
which should produce $123.00, for example.
However, each time I run the macro, the '£' and '‚¬' signs work perfectly but
the '$' sign always returns '‚¬' (e.g. ‚¬123.00).
Is there a way of replacing the 'NumberFormat =' definition ("$" & "0.00")
maybe by using an ASCII code, or CHR$ or any other method?
Frustration is setting in!
Any help gratefully received