View Single Post
  #1   Report Post  
Carla Bradley
 
Posts: n/a
Default 15 character field truncating

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