UK formats & more format choices

I'm in the UK and need to have UK formats. For example in Excel I need £ not $. 31/1/13 not 1/13/23. Also I like to show numbers in red when negative and some numbers without decimal places.

Dave Commented

I find it annoying trying to format the cell to uk date format and it wont change.