Is there a formula for this?

Do you mean that you want to change the number of decimal places shown for a given field (incl set to zero) or do you want a formula that will trim the decimal places when using a number from an existing field?

Hi Chris! Oh yeah, I meant trim or truncate

The easiest thing to do is just to create a formula field that is simply the name of the original number, but with the decimal places option set to zero.

Alternatively, you could use this formula to extract the integer part as text:

`Left(ToText([Decimal number]),Find(ToText([Decimal number]),".") - 1)`

Because it involves converting the number to text, you lose the thousands separator, and perhaps it becomes less useful for other reasons.

You donâ€™t need the ToText bit if all you want to do is truncate the number

Hi @Chr1sG !

It rounds up though i.e. 1.5 becomes 2.

Iâ€™d like for it to just disregard whatâ€™s after the decimal point.

I tried the formula (Left(ToText([Decimal number]),Find(ToText([Decimal number]),".") - 1)) but itâ€™s also giving me the same error message: â€śCannot convert Integer formula to Textâ€ť

Use the name of the original number field and substract 0.5 (no need for the ToText bit) e.g.

`[Formatted Decimal] - 0.5`

This formula will also work:

`ReplaceRegex( ToText( <your-value> ), "\.\d+$", "")`

Thank you so much! I couldnâ€™t check 2 â€śSolutionâ€ť boxes but both work. Iâ€™m working on converting decimal time into standard time.

Sounds like we need to log a request for a 12hr clock feature

Thanks @Matt_Blais

I know how powerful regex expressions can be when used appropriately, but I use them so infrequently that I always end up spending half my time trying to figure out the correct syntax!