The excel "Amount" Column I had convert to Number, however, it display as text, and it cannot sum when I create pivot table, who can help me solve this issue?

Lori · September 19, 2022, 3:26am

@rohith.prabhu
Thanks for you reply, which need enable Macro, any other method can solve this issue?
is studiox can solve this issue?

Topic		Replies	Views
Convert number text to number in excel and how to sum up the column? Help excel , uiautomation , studio	9	5458	July 24, 2023
Sum column, but the cell format is in text Activities excel , activities , question	4	767	February 27, 2023
Convert number text to number in excel and sum Help excel , activities , question	3	1698	January 12, 2021
How Convert Excel Column From Text To Number Format Studio studio , question	7	3426	January 20, 2022
How can i everything make it to sum of in pivot table Certification datatable , excel , studio	1	801	July 23, 2020