CODEWITHSUNDEEP
google-sheetsnumber-formattingcurrency-formatting
J.Doe
J.Doe

Reputation: 65

Convert 20,385.0 into 20 385,00 $ in a Google Spreadsheet

In my Google Spreadsheet, I often have to paste numbers with that similar format 20,385.0. I tried to press the dollar sign to convert it into 20 385,00 $, but it didn't work. I tried to format it with Format -> Number -> Custom Number Format, but I never succeeded it. How can I convert this format 20,385.0 into this format 20 385,00 $?

Upvotes: 1

Views: 35

Answers (0)

Related Questions