Hi,

Ok something is really bugging me. I'm setting a format in a cell to hh:mm, but when I click in that cell it shows as 'dd/mm/yyyy hh:mm' in the formula bar. No matter which format I change it to, it always shows that. However in other spreadsheets it shows as hh:mm.

Is there a setting or something I've not ticked or ticked?

Thanks