how many digits can "number" have?
There is a limit of 15 digits precision in Excel (you can use more
digits if you treat the values as text). This is a direct consequence
of the way Excel stores numbers in binary format, using 64 bits split
into mantissa and exponent as defined by IEEE. Many other software
applications use this same approach.
Hope this helps.
Pete
On Jun 23, 8:51*am, ViestaWu wrote:
Does anyone can tell me how many digits can a number show me with no
decimals? and why?
|