Remove a Decimal in Column without Rounding

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!