View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default stop numbers auto rounding

It may look rounded, but it is probably unrounded in reality. The 'rounding'
is probably just a visual effect of the format. Try increasing the number of
decimal places to check.

HTH

Bob

wrote in message
...
I am using Excel 2007. Does anyone know how to stop automatic rounding
of
numbers if i want to keep my sheet cells numbers format "general" so
that the exact number will be displayed i hop if worksheet change code
or function code ? Thanks.