Remove a Decimal in Column without Rounding

Lauryn Vogt

I have a column set up for a Retail Price, currently it looks like this: 3.99

I need to pull this column into another column with a column formula, but I need it to be formatted without the decimal, without rounding. So in the column formula I want it to pull in and look like this: 399.

The column formula is automatically combining multiple columns into one, both text and numbers.

Paul Newcome

Give this a try...

=("Category:" + Category@row + ", " + "Theme:" + [Theme Name]@row + ", " + "Ministry:" + Ministry@row + ", " + "Year:" + [Item Year]@row + ", " + "Translation:" + Translation@row + ", " + "Language:" + Language@row + ", " + "Product Type:" + [Product Type]@row + ", " + "MSRP:" + ([Retail Price]@row * 100))

Keep in mind though that because you are adding it to a text string, it will be converted to a text instead of a numerical value. It will still show as "399" instead of "3.99" though.

Bassam Khalil

Hi @Lauryn Vogt

Hope you are fine, could you please supply a screenshot for your sheet ( please remove any sensitive date).

Lauryn Vogt

In the retail price column is 3.99. In the Shopify Tags Column I have a formula pulling in several columns, adding text before each of them. I need to pull in the Retail Price Column too. But I need it to be formatted like: 399 instead of 3.99. I was hoping to not have to manually update the retail price column without the decimal.

Andrée Starå

Hi @Lauryn Vogt

The screenshot is too small to see the details, but try something like this.

=SUBSTITUTE([Retail Price]@row, ".", "")

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Couldn't you just multiply by 100? That would also keep it as a numerical value as opposed to a text value.

Andrée Starå

@Paul Newcome

Haha!

Good point!

Lauryn Vogt

how do I add the "multiply by 100" to this string of formula?

=("Category:" + Category@row + ", " + "Theme:" + [Theme Name]@row + ", " + "Ministry:" + Ministry@row + ", " + "Year:" + [Item Year]@row + ", " + "Translation:" + Translation@row + ", " + "Language:" + Language@row + ", " + "Product Type:" + [Product Type]@row + ", " + "MSRP:" + [Retail Price]@row)

Paul Newcome

Give this a try...

=("Category:" + Category@row + ", " + "Theme:" + [Theme Name]@row + ", " + "Ministry:" + Ministry@row + ", " + "Year:" + [Item Year]@row + ", " + "Translation:" + Translation@row + ", " + "Language:" + Language@row + ", " + "Product Type:" + [Product Type]@row + ", " + "MSRP:" + ([Retail Price]@row * 100))

Keep in mind though that because you are adding it to a text string, it will be converted to a text instead of a numerical value. It will still show as "399" instead of "3.99" though.