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

Options
jmhoward
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.

Thanks,

Jackie

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!