Subtotal by date shows US format rather than other way round

S

sarahmarsden

I have a spreadsheet which has data subtotalled by date. My date format
is dd/mm/yyyy, but the subtotals show mm/dd/yyyy. When I look in
'format cell' it shows my format is dd/mm/yyy, but even still it shows
the other way around.

How do I fix this?
 
Top