View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] regis.clement@googlemail.com is offline
external usenet poster
 
Posts: 1
Default Custom number format for basis points

Hi,

Is there a way to create a custom number format to display a number in
basis points, e.g.. to have 0.005 displayed as 50bp.
The 0%% format almost does it, except for the two trailing percent
signs...

Any help appreciated

Thanks,
Regis