| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollar / Euro sign
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| Dollar Sign | Excel Discussion (Misc queries) | |||
| How can I change dollar sybbol to euro symbol? | New Users to Excel | |||
| XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
| Can I disply Euro and Dollar Formats in the same spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
