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

@rohith.prabhu

I had tried use format cell and failed.

image