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
, ,
6

@Lori ,

So After format cell you are getting values in Number format in the given sheet (Sheet1)? Also Can you check once your pivot table and confirm everything is correct.