# Formatting of number columns may misrepresent values **URL:** https://community.glideapps.com/t/formatting-of-number-columns-may-misrepresent-values/58171 **Category:** Report a Bug **Created:** [February 19, 2023, 6:48pm UTC](https://community.glideapps.com/t/formatting-of-number-columns-may-misrepresent-values/58171 "2023-02-19T18:48:39Z") **Posts on this page:** 1 **Showing post:** 2
### 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: [February 19, 2023, 9:19pm UTC](https://community.glideapps.com/t/formatting-of-number-columns-may-misrepresent-values/58171/2 "2023-02-19T21:19:11Z")
This is a similar thread. Essentially numbers with currency are getting converted to text at some point, which treats the comma as a decimal. I think it’s specific to using the currency symbol. Maybe check to see if your column is set as a number column instead of text. In reality, you shouldn’t apply formatting in the google sheet and instead apply it in glide. If your column is a numeric column, then you can set precision, thousands separator, and currency symbol directly in the column configuration. > [@Can you sum a column based on which rows are displayed after an in app search bar search?](https://community.glideapps.com/t/can-you-sum-a-column-based-on-which-rows-are-displayed-after-an-in-app-search-bar-search/57711/16): > > OK, I’m able to reproduce it, but I’m not sure I fully understand what’s happening…but I kind of do…but I’m not sure I want to classify it as a bug yet. Can you show me how your SearchedValues column is configured? At some point that number is getting converted to text with the commas intact, and that throws the math column for a loop because it’s not expecting anything other than raw numbers, and by default it treats commas as decimals. If the IF column was returning a raw number without any… --- _[View the full topic](https://community.glideapps.com/t/formatting-of-number-columns-may-misrepresent-values/58171)._