i need to make excell keep 16 digit number intact. now scientific o
rouded expressions are allowed. Is this possible
--
Message posted from http://www.ExcelForum.com
JE McGimpsey - 09 Apr 2004 03:16 GMT
If you don't need to do math on it (i.e., it's a credit card number),
preformat the cell as Text or prepend an apostrophe (').
If you need more than 15 decimal digits of numerical precision, you'll
either need to use a different application, or load one of the add-ins
that claim to extend precision to 200 digits (do a Google search, there
are at least 2).
> i need to make excell keep 16 digit number intact. now scientific or
> rouded expressions are allowed. Is this possible?
Earl Kiosterud - 09 Apr 2004 03:18 GMT
You'll have to format the cells for text. Format - Cells - Number - Text.
Then type the numbers. Or precede each with an apostrophe (').

Signature
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
> i need to make excell keep 16 digit number intact. now scientific or
> rouded expressions are allowed. Is this possible?
>
> ---
> Message posted from http://www.ExcelForum.com/
Frank Kabel - 09 Apr 2004 09:14 GMT
Hi
if you really need to calculate with theses numbers (e.g. they are not
credit card or telephone numbers) see for one add-in:
http://www.big-numbers.com/
Note: haven't tested this add-in by myself

Signature
--
Regards
Frank Kabel
Frankfurt, Germany
> i need to make excell keep 16 digit number intact. now scientific or
> rouded expressions are allowed. Is this possible?
>
> ---
> Message posted from http://www.ExcelForum.com/