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

Hi

Have a look at the TRUNC worksheet function.

hth

Keith