Concatenate text and currency issue

I am trying to concatenate or JOIN a column with currency and standard text - I can do this, however it doesn't show zeros on the currency, for example; instead of £2.00 I get £2

Can anyone help as to how I can get the formula to exactly replicate the currency value. Obviously adding a zero to every result isn't an option as I don't want to have £1.570 for example.

Find more posts tagged with

Formulas

Accepted answers

All comments

John Jonassen

Hi @PeterR

I think this might serve you:

="Was £" + IFERROR(IF((LEN(MID([Std Sell Price in VAT]@row, FIND(".", [Std Sell Price in VAT]@row), 3)) - 1) = 2, IFERROR(LEFT([Std Sell Price in VAT]@row, FIND(".", [Std Sell Price in VAT]@row) - 1), [Std Sell Price in VAT]@row) + MID([Std Sell Price in VAT]@row, FIND(".", [Std Sell Price in VAT]@row), 3), IF((LEN(MID([Std Sell Price in VAT]@row, FIND(".", [Std Sell Price in VAT]@row), 3)) - 1) = 1, IFERROR(LEFT([Std Sell Price in VAT]@row, FIND(".", [Std Sell Price in VAT]@row) - 1), [Std Sell Price in VAT]@row) + MID([Std Sell Price in VAT]@row, FIND(".", [Std Sell Price in VAT]@row), 3) + 0, "")), [Std Sell Price in VAT]@row + ".00")

PeterR

That gives me unparseable unfortunately.

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.