View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default when i type 5 then it shows.006

In addition to Eduardo's suggestion, you might check Tools - Options - Edit,
and make sure you don't have "Fixed decimals" activated.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gauri" wrote:

hi all
i am new to excel,i was making some sheet and when i type number 5 or any
number it show.005,please let me know what to do