# Row number in report column is treated as text **URL:** \ **Category:** Bugs & Issues\ **Created:** [January 18, 2023, 8:10am UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822 "2023-01-18T08:10:48Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 18, 2023, 8:10am UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/1 "2023-01-18T08:10:49Z")
I’m trying to use an external CSV as input to a table view report. I want to sort by [Row Number] which is indicated as a Number field. This is generated by Fibery I guess because the information is not in the CSV file. But using the field Row Number in a column in the table view, it is treated as text and thus the order is not correct. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/010d534908fd51e0042b1fd16f30c59daa623cd2.png) ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [January 18, 2023, 8:14am UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/2 "2023-01-18T08:14:41Z")
I also tried looking for a function to convert text to number but only find the other way around. ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [February 11, 2023, 11:19am UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/3 "2023-02-11T11:19:41Z")
Can anyone else confirm this as a bug? Or know of a possible workaround? It would seem that identifying the Fibery generated “# Row Number” as a number instead of text would solve the problem. ---
**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:** [February 11, 2023, 11:55am UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/4 "2023-02-11T11:55:28Z")
Have you chosen a sort order for the column? ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [February 11, 2023, 12:03pm UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/5 "2023-02-11T12:03:34Z")
Yes, but sorting Text gives 1, 10, 11, 12…2, 20, 21 etc. I’ve set the order to Ascending ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [February 12, 2023, 2:19pm UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/6 "2023-02-12T14:19:15Z")
@Chr1sG Here’s a simple space to recreate the problem. > **[CSV — Fibery](https://shared.fibery.io/sign-up?appShareId=409b4be6-c107-48fa-94c0-35f21bea3dc5-csv)** > > Create a Fibery account to replace isolated tools and bring everyone together. I hope the report view is shared as well. If not, here’s the CSV link used (from Google Sheets). [https://docs.google.com/spreadsheets/d/e/2PACX-1vQ1pigHcXbh5Kfr6dIa-ThXd76ymvrc7uq--Nbemzmn0iGOMoCdP2HRgy7ctGKMjsO\_KyQi67rKLQrT/pub?gid=0&single=true&output=csv](https://docs.google.com/spreadsheets/d/e/2PACX-1vQ1pigHcXbh5Kfr6dIa-ThXd76ymvrc7uq--Nbemzmn0iGOMoCdP2HRgy7ctGKMjsO_KyQi67rKLQrT/pub?gid=0&single=true&output=csv) Then I use `# Row Number` in the first column and sort by ascending order. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3640e6a7b00a853d367e84cab465483959453c62.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:** [February 12, 2023, 4:54pm UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/7 "2023-02-12T16:54:40Z")
So the row number functions a bit like the public if in a normal database: it is a number stored as a string. If you want to sort as a number, I suggest the following (it assumes you have less than 1000 rows, but you can scale if you have more): ![Screenshot_20230212-174830~2](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/161991f17a7a87f8c19c72071bd66663c1d02438.png) ---
**Author:** ![aoe](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aoe/32/6018_2.png) [@aoe](https://community.fibery.io/u/aoe)\ **Post date:** [February 12, 2023, 5:34pm UTC](https://community.fibery.io/t/row-number-in-report-column-is-treated-as-text/3822/8 "2023-02-12T17:34:37Z")
That works as a workaround, thanks!