Forum Discussion
Pivot table- number becomes date when expand the details
Hi All, I have a problem when I expand the details from Pivot table, all the data in "number" format have been shown as "date" format. How can I solve it? Thanks so much.
Thanks for the reply. However, the other real date fields become "number" format too.
It would be better to assign a number format for those columns. The same issue may come out again if the format in is still in General.