View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robaroo Robaroo is offline
external usenet poster
 
Posts: 1
Default How to Format numbers from percentage points to basis points

Excel 2007; I need to know how to format a range of cells that contain
numbers that are percentages to display as basis points. An example would be
a cell that I have where the value is .035 and is displayed as 3.5% in this
example the result I want displayed would be 350. ( I suppose the
formatting technique I'm looking for is the opposite of moving from millions
to thousands using the comma in custom formatting area) Thanks for your help.