LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 05:39 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 12:18 AM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 7th 04 11:19 PM
Creating a new field Michael Rodriguez Excel Discussion (Misc queries) 3 December 4th 04 01:06 AM
how do you set up a mandatory field in Excel? Lisa Excel Discussion (Misc queries) 2 November 30th 04 11:20 PM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"