Get dollar amounts in K to show up as full numbers?

jmhoward ✭✭✭✭✭
edited 07/13/23 in Formulas and Functions

Hi there,

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.




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!