1000000000000012

is 16 digits. One more than excel can keep track of.

Either start with an apostrophe:
'1000000000000012

or preformat the cell as Text and then type your data.



wrote:

Thanks for the rely. It actually reformats the cell on 12
digits as well (not 11 and below).

Also, it changes the last number to a zero if I format the
cell as 'number'.

e.g.

1000000000000012 will change to 1000000000000010 with a
formatted number. I suppose this makes perfect sense since
the number is so great but I don't want it to reformat the
way it looks. I'd rather have all those digits.

Very odd...

-----Original Message-----
Excel has only 15 digit precision, precede the entry with
an apostrophe to
make it text


Regards,

Peo Sjoblom

"Angelo" wrote:

Hi,

I have a column that is dedicated to mac addresses. Some
are letters and numbers and some are just numbers (16
chars). I want the cell to leave the input values as they
are and not format them in any way. Here's the problem I
have.

I know why it is doing this, but I want to show the numbers
exactly as I input them.

When I type 16 chars of numbers only, the look changes
to this:

1.24865E+15

from this:

1248651497265430

i don't want to have to format every cell that has a
numbers only because i never know which cell that will be.
I just want it to be general across the board but it
changes it for number values.

Is there any way of setting excel to leave the input values
as they are and not reformat them?

Thanks.


.


--

Dave Peterson