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

Paul Newcome

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.

Paul Newcome

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.