I am having Excel document where only one cell value from Number/Currency to change as Canadian French currency format where commas will be showing space and decimal point will come as comma.
Example : $1,500,000.00 to 1 500 000,00 $
when i use below formula that is working but I need to use this in VBA macro and I honestly don't know how i can add in Macro.
=SUBSTITUTE(TEXT(A1, "# ### ##0.00 $"),".",",")