Sort by value, rather than alphabetically
My query is set to return Date and Hour.
Sorting is set to sort Date (Ascending) and then Hour (Ascending) as the secondary sort.
The problem is that it sorts the hours alphabetically rather than by value.
Instead of 0,1,2,3...
How can I fix this? I've tried setting the number format in Google Sheets to "00" (which forces a leading zero onto one-digit numbers) on this column but that doesn't help. Every time this query updates, I have to manually sort the table.