Help me adjust this code to suit my need

[kelly mort]

I came across this code while searching the from the net . I need some explanation to what is happening so I can modify it to suit my needs. Why the number 809? Should that number be used for all other symbols ? Please help

[COLOR=#000000][FONT=Courier]With Me.MBStake[/FONT][/COLOR][COLOR=#000000][FONT=Courier].Text = Application.Text(Range("MBStake").Value, "[$£-809]#,##0.00;-[$£-809]#,##0.00")[/FONT][/COLOR][COLOR=#000000][FONT=Courier] 
   If Range("MBStake").Value < 0 Then[/FONT][/COLOR][COLOR=#000000][FONT=Courier] 
       .ForeColor = vbRed[/FONT][/COLOR][COLOR=#000000][FONT=Courier] 
   Else[/FONT][/COLOR][COLOR=#000000][FONT=Courier] 
       .ForeColor = vbBlack[/FONT][/COLOR][COLOR=#000000][FONT=Courier] 
   End If[/FONT][/COLOR][COLOR=#000000][FONT=Courier]End With
[/FONT][/COLOR]

 

[wideboydixon]

The 809 is a hexadecimal value. Decoding to decimal gives 2057 which is the LCID (Locale ID) for Great Britain. So the "[$£-809]" part reads as "prefix with the Great Britain £ symbol". If you wanted to force US$ then you could use [$$-409] for example.

Hope that helps.

WBD

 

[kelly mort]

Okay great. I am in ghana how do I get the Cedis symbol?

Or if not possible then how will I omit the symbol all together?
Thanks

 

[wideboydixon]

This?

"[$GH¢]#,##0.00;-[$GH¢]#,##0.00"

WBD

 

[kelly mort]

This?

"[$GH¢]#,##0.00;-[$GH¢]#,##0.00"

WBD

Exactly.

Thanks very much

Kelly

 

[kelly mort]

This?

"[$GH¢]#,##0.00;-[$GH¢]#,##0.00"

WBD

Hello,

I just found out the symbol is not showing.

What might be the cause?

 

[wideboydixon]

Not sure. It's working without issue on Excel 2016.

WBD