Hi Andy,
Not correct.
First, I assume you mean 10-*digit* binary numbers; 10-character binary
numbers would (in most people's opinion) be 80 bits; try figure out what
numbers you can store in an 80-bit binary.
Excel's *precision* is 15 decimal digits. It can store numbers as large as
9.99999999999999E308, but it loses some precision. By the way, 15 digits of
precision means you can loose something like 1/1000,000,000,000th of a
percent in precision. Few application areas require more.
However, if you do require more precision, download the XNUMBERS utility
he
http://digilander.libero.it/foxes/index.htm
If you just need large "numbers" that are really just identifiers with which
you don't have to calculate, like credit card numbers, use text. One way is
to format cells as text before entering the number, another is to precede
the number with a single quote.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Andibevan" wrote in message
...
Hi All,
As far as I understand, Excel can only handle 10 character binary numbers.
Is there any code anywhere which allows the handling of larger binary
numbers.
Ta
Andi