Not sorting Hour of Day correctly

[jonnyp47]

Hello,

I have had no issues until now creating pivot table. Hour of Day is placed in Column, however not sorting from 0 to 23. Tried clicking sorting options and unclicking automatic; sorts differently but not in order.

Password to excel sample document is "icu"

HOD Example PIcture.JPG

[MrShorty]

The columns in the pivot table appear to be sorted correctly for "text sort order." When I look at column B in the source data, I see a green triangle with the "number stored as text" error message. I suspect that the problem will resolve itself if you convert the numbers stored as text to numbers (assuming that would be allowed), then refresh the pivot table. Strategies for converting numbers stored as text to numbers: https://support.microsoft.com/en-us/...rs=en-us&ad=us

[jonnyp47]

Solved. Thank you kindly.