View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
Excel only supports 15 significant digits. If you need to enter more (e.g. a
credit card number) two options:
1. Preformat the cell as 'Text' (Format - Cells')
2. precede the entry with an apostrophe. e.g.
'1234567890123456

--
Regards
Frank Kabel
Frankfurt, Germany
"Carla Bradley" schrieb im
Newsbeitrag ...
This isn't really a question. I just need to explain properly from a more
authoritative voice than myself why something is happening to a client.
She
is entering a 15 digit character in excel (all numbers). It is truncating
it
down to a few numbers plus that e+ thing. For example entering
153469874563216 becomes 1.5437E+14 when the cell is formatted as general
or
number. I explained as best I could why and to format the cell as text or
add
a single quote to the beginning, but she said it didn't work for her that
way
before. She has Word XP and I had several others try and it did the same
thing to them. I have Word 2003 and it worked fine for me, no truncating.
I
just need something intelligent to tell this person, because she didn't
like
my explanation.

Thanks,
Carla