How do i get the pivot table to use re-formatted data?

Question

I reformatted the time to use military time in column 😧

When inserting a pivot table, it still uses the original format of time:

How do i get the pivot table to recognize the 24 hour time?

juliano-petrukio · Answer

Its necessary you format the pivot table format as well. You just right click over fields and select Value Field Setting &gt;&gt; Format Number ...

juniebug · Answer

Juliano-Petrukio&nbsp;Hi, i did that and im not sure which one to select?&nbsp;thanks for your help

yea_so · Answer

juniebug&nbsp;&nbsp;You cannot.&nbsp; You'll have to get creative

Forum Discussion