Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) | |||
Creating a new field | Excel Discussion (Misc queries) | |||
how do you set up a mandatory field in Excel? | Excel Discussion (Misc queries) |