Get dollar amounts in K to show up as full numbers?
jmhoward
✭✭✭✭✭
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

In another column you would need something like:
=VALUE(SUBSTITUTE(SUBSTITUTE([F USD]@row, "$", ""), " K", "")) * 1000
Then format the new column for the appropriate currency.
Answers

In another column you would need something like:
=VALUE(SUBSTITUTE(SUBSTITUTE([F USD]@row, "$", ""), " K", "")) * 1000
Then format the new column for the appropriate currency.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!