Change Currency to RM

[kumara_faith]

Hi,

I am trying to change the currency in a spreadsheet that I have from symbol $ to RM.

Example: Currently the cell values are $5000.00. I would like to change it to RM5000.00

I tried changing in Format Cells>>Custom>> but it did not work.

Tried changing in Regional and Language settings in Windows but I am not sure how to go about this.


Appreciate help.

 

[JazzSP8]

I don't think this will work if the data in the cells is literally "$5000.00", if it is just 5000.00 formatted as currency then try custom format of;

"RM"#,##0.00

HTH

 

[kumara_faith]

Thank you Jazz! That worked. Appreciate your time and patience.

 

[lenze]

Create a "Custom Style". Format>Style. Select a name (Say myCurr) and then choose modify. On the Number tab, custom format as suggested by Jazz. Exit via OK. Now you can easily apply this style to any range on demand.

lenze

 

[fazna ali]

Why the solution didn't work for me?
I've try to write

[B]Sub Format_Cell_Currency_ringgit_myr()[/B]

[B]Selection.NumberFormat = "RM"#,##0.00[/B]

[B]End Sub[/B]

but it happen to have Compile error:Syntax Error
Please help to explain to me.
Thank you in advance.

 

[VoG]

Try

Sub Format_Cell_Currency_ringgit_myr()

Selection.NumberFormat = """RM""#,##0.00"

End Sub

 

[cml19722000]

Selection.NumberFormat = """RM"" #,##0.00"

 

[fazna ali]

WOW! it works! thank you very much cml19722000!
but, can you explain to me the coding.
why is it necessary to write like that to get the desired output?

 

[fazna ali]

oyeah, tenks to VoG too!

 

[cml19722000]

Hi Fazna,

This is syntax for VBA when we want to include "" inside our script.

Thanks.