Get dollar amounts in K to show up as full numbers?
I have a sheet where dollar amounts come from Excel into the sheet as $x K. I would like to have these format as $x,000.
Is there a way I can do this using a formula? Interestingly, when I use import functionality, the numbers convert automatically. But in this use case, users will be copying and pasting single rows.
Help Article Resources
Check out the Formula Handbook template!