stop numbers auto rounding

[abu abdullah........halsaeed85]

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.

 

[Bob Phillips]

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

 

[Ron Rosenfeld]

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.

1. The cell must be wide enough to accommodate the unrounded number.
2. Be aware that the maximum precision is 15 digits for an integer. If you
have a longer number, you will have to enter it as text by either formatting
the cell as text before you enter the value; or preceding the value with a
single quote (which will not be displayed in the cell).
--ron