Custom currency format (Example: $50,800.00 to 5080000)

[dterest]

Hello,

I have been trying to find a way to customize the currency format in order to eliminate the symbol ($), comma and decimal point keeping the decimal information

For example: $50,800.00 to 5080000

Any help will be greatly appreciated.
Thanks

 

[Oaktree]

Welcome to the board!

Perhaps: =TEXT(A1*100,0)