ExcelBanter - £#,###,"k" format tweak

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - £#,###,"k" format tweak (https://www.excelbanter.com/excel-worksheet-functions/245362-%C2%A3-k-format-tweak.html)

David

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

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

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

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

David

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

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

All times are GMT +1. The time now is 10:19 AM.