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?

[rohith.prabhu]

Hello @Lori ,

Please refer to this thread :

Need to Change the format of a column in Excel Sheet

@sandhya_koilada - Please try like this… [image] vba code: 1000Seperator.zip (305 Bytes) Make sure , you macro setting turned on under “Trust Center”, if not this won’t work… [image] My Input and Output: [image] Here is reference for the number formats… Hope this helps… Note: Even I am not good with VBA, found this code somewhere for converting text to number, used the same code to modify user case it worked…