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 (Li)]

After Format Cell, when I click right mouse and click “Format Cell” and found the column had format as number as top topic screenshot, however, it still display as text feature, and when create pivot table, it still cannot sum.