Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop numbers auto rounding
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop numbers auto rounding
On Tue, 2 Feb 2010 04:04:00 -0800 (PST), "abu
" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop excel from rounding my numbers up? | Excel Discussion (Misc queries) | |||
To stop the rounding of numbers | Excel Discussion (Misc queries) | |||
How do I get excel to stop rounding numbers | Excel Discussion (Misc queries) | |||
Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
How do I stop rounding numbers? | Excel Discussion (Misc queries) |