Requirement: I have one excel which download from Oracle and I save as excel, the data display text format however they are general format, and I had convert “Amount” column to Number , my issue is when i use the data source create pivot table, it can not sum amount, I need you help. thanks. [im…

Hello @Lori , Please refer to this thread : [image] Need to Change the format of a column in Excel Sheet Studio @sandhya_koilada - Please try like this… [image] vba code: 1000Seperator.zip (305 Bytes) Make sure , you macro setting turned on under “Trust Center”, if no…

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?

Help Studio

system (system) Closed September 26, 2022, 9:15am 8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

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

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?

Related topics