View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 106% to this please 6%

You could try this...

=MOD(A1/A2,1)

and format the cell as percentage (specifying the number of decimal places
you want).

--
Rick (MVP - Excel)


"Steved" wrote in message
...
Hello from Steved

How do I please change 106% to 6%

Please A formula for below to acheive the above

32297966
30400962
=6%

Thankyou.