Forum Discussion

LoisRockwell3's avatar
LoisRockwell3
Qrew Member
4 years ago

Remove commas (newbie here) from imported numbers

Hello - I've spent an hour searching the community and cannot find an answer to removing the commas to my uploaded numerical column.  I was my numerical field to look like this: 123456789 not; 123,456...
Data import and export
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Lois, if the number of digits is 12 or less, then you should be able to change this to a numeric field and set the commas not to show.

If it is more than 12 digits, then you will need to leave it as a ext field type.

Are you uploading from Excel?  is this a numeric field in excel or a text field in excel?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------