# Remove digits after decimal point (formula) **URL:** \ **Category:** Get Help\ **Tags:** formulas\ **Created:** [October 6, 2021, 3:07am UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101 "2021-10-06T03:07:59Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![v3j](https://avatars.discourse-cdn.com/v4/letter/v/f07891/32.png) [@v3j](https://community.fibery.io/u/v3j)\ **Post date:** [October 6, 2021, 3:07am UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/1 "2021-10-06T03:07:59Z")
Is there a formula for this? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 11:23am UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/2 "2021-10-06T11:23:52Z")
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? ---
**Author:** ![v3j](https://avatars.discourse-cdn.com/v4/letter/v/f07891/32.png) [@v3j](https://community.fibery.io/u/v3j)\ **Post date:** [October 6, 2021, 12:39pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/3 "2021-10-06T12:39:55Z")
Hi Chris! Oh yeah, I meant trim or truncate 🙂 ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 1:20pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/4 "2021-10-06T13:20:40Z")
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. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/c8816fdc3de8c6ff8fb8266f463fd762411a66ff.png) 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. ---
**Author:** ![v3j](https://avatars.discourse-cdn.com/v4/letter/v/f07891/32.png) [@v3j](https://community.fibery.io/u/v3j)\ **Post date:** [October 6, 2021, 3:13pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/5 "2021-10-06T15:13:01Z")
Thanks Chris! I’m getting an error message. It won’t allow me to convert the number to text 😢 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/59695eb20307541fd9369c19f6da2697bdee988a.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 3:24pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/6 "2021-10-06T15:24:16Z")
You don’t need the ToText bit if all you want to do is truncate the number ---
**Author:** ![v3j](https://avatars.discourse-cdn.com/v4/letter/v/f07891/32.png) [@v3j](https://community.fibery.io/u/v3j)\ **Post date:** [October 6, 2021, 4:03pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/7 "2021-10-06T16:03:59Z")
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” ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 4:48pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/8 "2021-10-06T16:48:04Z")
Use the name of the original number field and substract 0.5 (no need for the ToText bit) e.g. `[Formatted Decimal] - 0.5` ---
**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Post date:** [October 6, 2021, 5:33pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/9 "2021-10-06T17:33:59Z")
This formula will also work: `ReplaceRegex( ToText( ), "\.\d+$", "")` ---
**Author:** ![v3j](https://avatars.discourse-cdn.com/v4/letter/v/f07891/32.png) [@v3j](https://community.fibery.io/u/v3j)\ **Post date:** [October 6, 2021, 6:26pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/10 "2021-10-06T18:26:18Z")
Thank you so much! I couldn’t check 2 “Solution” boxes but both work. I’m working on converting decimal time into standard time. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f206db6963d1768627060daa33180ba40fd89c77.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 7:29pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/11 "2021-10-06T19:29:16Z")
Sounds like we need to log a request for a 12hr clock feature 😉 ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 6, 2021, 7:31pm UTC](https://community.fibery.io/t/remove-digits-after-decimal-point-formula/2101/12 "2021-10-06T19:31:39Z")
> [@Matt\_Blais](#): > > ReplaceRegex( ToText( ), “.\d+$”, “”) 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!