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

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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.