View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
yasser yasser is offline
external usenet poster
 
Posts: 13
Default how i can show only the constant number after the comma

dear sir
is there any can help me
how i can show the constant number after the comma with out showing the
fraction
and with out changing the number.
example: 800 * 30 = 26.6666
i want the result after typing the formua to show only the 26 with out the
fraction
many thanks
yasser