View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default £#,###,"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