why does excel change my numbers?
On Nov 4, 10:30*am, brenda wrote:
Subject: why does excel change my numbers?
Without more information (that's why God created the text body), it is
anyone's guess.
If you are trying to enter a number with more than 15 digits, you are
exceeding Excel's data entry limit. It recognizes only the first 15
digits.
If you want to use the number in computation, you are out of luck.
If the number will not be used in computation -- for example, if it is
an identifier (serial number, tax id, etc) -- you can enter the number
as text by prefixing it with an apostrophe (single quote). For
example '12345678901234567890.
Next time, post your question in the text body as well as in the
subject line. And provide a reasonable explanation of the
circumstances.
|