How to add a '₹' into a cell using excel vba (format a cell with a Currency symbol '₹' )

Question

Hi I am trying to format a cell using below code and I am expecting to set the currency symbol of that cell as '₹' Where i am getting INR values.

But when I add below VBA code, it remove the '₹' with a '?'

Selection.NumberFormat = "[$₹-hi-IN]#,##0.00"

VBA not able to recognise this symbol, Is it possible get this code working....

Thanks in Advance

Answer 1

Selection.NumberFormat = "[$" + ChrW(&H20B9) + "-hi-IN]#,##0.00"