# How to round to number? **URL:** \ **Category:** Ask for Help\ **Created:** [June 26, 2020, 1:00pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493 "2020-06-26T13:00:29Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Golf\_en\_la\_Nube](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_en_la_nube/32/9593_2.png) [@Golf\_en\_la\_Nube](https://community.glideapps.com/u/Golf_en_la_Nube)\ **Post date:** [June 26, 2020, 1:00pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/1 "2020-06-26T13:00:29Z")
Hi, I need to round two numbers and then add them together. I read several articles in the forum but I can’t find any solution, is there currently? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 26, 2020, 1:26pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/2 "2020-06-26T13:26:18Z")
You can use rounding in Numbers column inside the Glide Editor, then use a Math column to add them together. ---
**Author:** ![Golf\_en\_la\_Nube](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_en_la_nube/32/9593_2.png) [@Golf\_en\_la\_Nube](https://community.glideapps.com/u/Golf_en_la_Nube)\ **Post date:** [June 26, 2020, 1:33pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/3 "2020-06-26T13:33:21Z")
yes, but the problem is that it shows the rounded number but when I need to do mathematical operations I don’t get the same result, specifically I need to add two numbers with decimals, which I must round, add them, and to that sum divide it by 3/8, as I cannot (or I don’t know how to) rounding the problem is that the final number if I always get the same when adding the two numbers with decimals, doing the math and rounding off the final number. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 26, 2020, 1:42pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/4 "2020-06-26T13:42:11Z")
Move the rounded values to template columns. Then use the template columns in the math formula. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 26, 2020, 2:11pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/5 "2020-06-26T14:11:01Z")
This is correct. Often i’ll need to convert math columns to templates in order to get a string value of the number before adding them together. I mention this in a recent post: > [@How-To: Custom Rating Component](https://community.glideapps.com/t/how-to-custom-rating-component/11286): > > wave Hey all! I know Glide came out with their own Ratings component, but it doesn’t Roll up averages over user specific columns. I managed to come up with a custom-built solution that’s an improvement to a simple drop down menu of ratings. Here’s how: [[Glide: Create your own 5-Star (or whatever) Rating Component] ](https://www.youtube.com/watch?v=O7TEF5z5t7U) If you’d like to play around with an example, visit my Experiments app and visit the Ratings tab: ---
**Author:** ![Golf\_en\_la\_Nube](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_en_la_nube/32/9593_2.png) [@Golf\_en\_la\_Nube](https://community.glideapps.com/u/Golf_en_la_Nube)\ **Post date:** [June 26, 2020, 8:18pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/6 "2020-06-26T20:18:55Z")
Thanks !! ---
**Author:** ![Jose\_Abelardo\_Martin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jose_abelardo_martin/32/11392_2.png) [@Jose\_Abelardo\_Martin](https://community.glideapps.com/u/Jose_Abelardo_Martin)\ **Post date:** [July 31, 2020, 4:01pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/7 "2020-07-31T16:01:41Z")
Thanks so much! totally worked, hope they implement a solution soon ---
**Author:** ![Gary\_Biagioni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_biagioni/32/4201_2.png) [@Gary\_Biagioni](https://community.glideapps.com/u/Gary_Biagioni)\ **Post date:** [March 6, 2021, 1:13pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/8 "2021-03-06T13:13:15Z")
One of the issues here is that you can not limit the number entry to the number of decimal places you allow in the sheet. Take the example of entering hours, minutes, seconds. I do not want to allow the hours or minutes to have a decimal place but seconds have. In the number entry I can not limit the number of decimals. So if the user enters 2.6 minutes when I figure out the seconds that is it comes out incorrect. Man it would be better if they did all the math in real numbers and limited the input and gave me a round function for when I want an integer. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 6, 2021, 2:26pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/9 "2021-03-06T14:26:18Z")
Ok, I understand the decimal issue with user input, but there are round, trunc, and other functions to trim off any decimals. Just wasn’t sure you were aware based on your last statement. ---
**Author:** ![Gary\_Biagioni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gary_biagioni/32/4201_2.png) [@Gary\_Biagioni](https://community.glideapps.com/u/Gary_Biagioni)\ **Post date:** [March 6, 2021, 3:50pm UTC](https://community.glideapps.com/t/how-to-round-to-number/11493/10 "2021-03-06T15:50:17Z")
Thanks. I was aware.