Currency / number formatting (thousands / millions)

Hi All,

I'm using the following format for values with millions £#.00,,"m";; and this format for values with thousands £0.0,k. I would like to combine those formats into one. In addition, I would like to hide zeros, as I did in the custom format for millions. Any help will be greatly appreciated.

Kind regards,
Konrad

Cells contain formulas in most of the cases.