£#,###,"k" format tweak

[David]

Custom number format above gives the following result
1) Value = 50,000; Display = £50k
2) Value = 0; display = £k
#1 gives me what I require, but I would like to force £0 to display for #2
above
Any advice will be appreciated

 

[Mike H]

david,

Try this

£#,##0,"k"

Mike

 

[David]

Thanks Mike
I pressed the "yo d man" button

david,

Try this

£#,##0,"k"

Mike