# šŸ’Æ Number formats **URL:** \ **Category:** General\ **Created:** [March 6, 2020, 12:20am UTC](https://community.glideapps.com/t/number-formats/5226 "2020-03-06T00:20:20Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 6, 2020, 12:20am UTC](https://community.glideapps.com/t/number-formats/5226/1 "2020-03-06T00:20:20Z")
Number columns can now be formatted in Glide: ![2020-03-05 16.15.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6abaec75fbdbb42a674b493ac802561f3128bf81.gif) ---
**Author:** ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)\ **Post date:** [March 6, 2020, 12:22am UTC](https://community.glideapps.com/t/number-formats/5226/2 "2020-03-06T00:22:34Z")
Thanks heaps!! ā¤ā¤ā¤ ---
**Author:** ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)\ **Post date:** [March 6, 2020, 12:42am UTC](https://community.glideapps.com/t/number-formats/5226/3 "2020-03-06T00:42:03Z")
Top cool ! šŸ‘šŸ» ---
**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:** [March 6, 2020, 2:01am UTC](https://community.glideapps.com/t/number-formats/5226/4 "2020-03-06T02:01:15Z")
Just stumbled upon this as I was reworking an app! This is awesome! ![Screen Shot 2020-03-05 at 9.00.11 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a9cbefbf149bda1ec82f75fd151c612501aac081.png) ---
**Author:** ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)\ **Post date:** [March 6, 2020, 3:50am UTC](https://community.glideapps.com/t/number-formats/5226/5 "2020-03-06T03:50:15Z")
WOW !!! šŸ¤— šŸ¤— ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [March 6, 2020, 6:36pm UTC](https://community.glideapps.com/t/number-formats/5226/6 "2020-03-06T18:36:49Z")
Great! ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [March 7, 2020, 11:57am UTC](https://community.glideapps.com/t/number-formats/5226/7 "2020-03-07T11:57:09Z")
just in time too! I began searching for a solution to this problem yesterday! I do have another number format problem with dates though. A few columns in my app work out the difference between two date/times and spits out the result as a number (i.e, 11:50 is formatted as 43897.4930555556) in my sheet. The value is input from my app into the the sheet using a form component (which requires a date//time selector, when i ONLY need a time selector ā€¦ [more on that here](https://community.glideapps.com/t/time-picker/774/7)). The sheet also has an array formula to perform the difference calc, which is also formatted in as a number. any suggestions on how to have the results in my sheet automatically formatted to a time format? ---
**Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\ **Post date:** [March 7, 2020, 1:54pm UTC](https://community.glideapps.com/t/number-formats/5226/8 "2020-03-07T13:54:40Z")
Now we just need to have this option in the calculable column > [@fish\_cake Rollups!](https://community.glideapps.com/t/rollups/4509/5): > > Hi @tru! How do you envision users using ā€œsome trueā€ vs ā€œtrueā€ (thatā€™s a lot of tru/true)? Also, would LOVE the ability to filter the Rollup by another column as well (eg count all items in a column that match true in another column or sum all items that match a users email address in another column) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [March 7, 2020, 2:42pm UTC](https://community.glideapps.com/t/number-formats/5226/9 "2020-03-07T14:42:59Z")
Rollups and other computed columns are supposed to take the number formats from their input columns. They currently donā€™t, which is a bug, but itā€™ll be fixed soon, probably Tuesday. ---
**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 7, 2020, 5:29pm UTC](https://community.glideapps.com/t/number-formats/5226/10 "2020-03-07T17:29:16Z")
Are you looking for something like this? Just make it part of your arrayformula ``` =text(F2, "HH:MM") ``` ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [March 7, 2020, 11:21pm UTC](https://community.glideapps.com/t/number-formats/5226/11 "2020-03-07T23:21:36Z")
no dice ā˜¹ ---
**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 8, 2020, 12:40am UTC](https://community.glideapps.com/t/number-formats/5226/12 "2020-03-08T00:40:46Z")
Does that mean it didnā€™t work or itā€™s not what you want? ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [March 8, 2020, 1:55am UTC](https://community.glideapps.com/t/number-formats/5226/13 "2020-03-08T01:55:02Z")
apologies, i meant it didnt work for me. my formula looks like this =ArrayFormula({ā€œRemaining Timeā€;ArrayFormula(if(len(A2:A)\>0,if(G2:G-$J$1\ **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 8, 2020, 3:07pm UTC](https://community.glideapps.com/t/number-formats/5226/14 "2020-03-08T15:07:56Z") It worked for me. The only thing I changed is to convert reenter the double quotes, since they sometimes paste weird in the forum and I changed the 30/12/1899 to 12/30/1899 since Iā€™m in the US. You shouldnā€™t have to change the date to MM/DD/YYYY, but try this formula with the corrected double quotes. `=ArrayFormula({"Remaining Time";ArrayFormula(if(len(A2:A)>0,if(G2:G-$J$1 **Author:** ![Alex\_Calandrino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alex_calandrino/32/335_2.png) [@Alex\_Calandrino](https://community.glideapps.com/u/Alex_Calandrino)\ **Post date:** [March 9, 2020, 1:29pm UTC](https://community.glideapps.com/t/number-formats/5226/15 "2020-03-09T13:29:27Z") Thank you @Mark you are the guy ---
**Author:** ![Hemmings](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hemmings/32/3799_2.png) [@Hemmings](https://community.glideapps.com/u/Hemmings)\ **Post date:** [March 9, 2020, 11:30pm UTC](https://community.glideapps.com/t/number-formats/5226/16 "2020-03-09T23:30:50Z")
Thanks @Jeff_Hager. Update - it did work for me in the end, i think there was a bug in the sheet because the format didnā€™t update until I checked again the next day. Only problem is that it broke formula in another cell that was expecting a date value where it was now getting text. To be honest, I was looking a solution that was human readable, but iā€™ve gone back to the old way as I need the other formulaā€™s to work. Iā€™m based in the UK so iā€™ve got the dates the other way round. Thanks again ---
**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 10, 2020, 12:29am UTC](https://community.glideapps.com/t/number-formats/5226/17 "2020-03-10T00:29:12Z")
You can always have 2 columns with formulas. One for the other formulas, and one for the human readable version that used for display only.