Pivot table- number becomes date when expand the details

Question

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.
&nbsp;

haytham amairah · Answer

Try this:
&nbsp;
Select all cells, then press Ctrl+Shift+~

fifis family · Answer

Thanks for the reply. However, the other real date&nbsp;fields become "number" format too.&nbsp;

haytham amairah · Answer

Sorry about that,&nbsp;I had to say: select all the numbers that converted to date format, then&nbsp;press (Ctrl+Shift+~) not select all cells!
Anyway, with regards to the real dates that converted to number format, select them, press Ctrl+1 and choose date category, then select the date format that you want.

willy lau · Answer

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.

Forum Discussion

Pivot table- number becomes date when expand the details

Share

Resources