View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Milwpacker Milwpacker is offline
external usenet poster
 
Posts: 2
Default deleting percentage sign

I want to delete the percentage sign (%) in a cell that is formulated for
mpg's. How do i do that so it shows MPG or nothing at all and still has a
one decimal point answer such as 24.5 ??