Thanks Mike
I pressed the "yo d man" button

"Mike H" wrote:

david,

Try this

£#,##0,"k"

Mike

"David" wrote:

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