Can I change the 15-digit limit in Excel for numbers ?

Bernard Liengme

Posts: n/a

Are they really numbers? Do you do math on them?
If not, then format them as text
If yes, try the XNUMBER add-on (locate with Google)

beat wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Johan" wrote in message
...
I work with numbers containing more than 15 digits, when I import it from a
text file Excel rounds the last three digits to zero and I lose my number
(which I need to find it back in a database), how can I modify this ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
How to change the color of all series in an excel chart in one go.	Marielle	Charts and Charting in Excel	2	May 3rd 23 07:45 PM
How to change the color of all series in an excel chart in one go.	Mz2	Charts and Charting in Excel	1	January 20th 05 01:07 AM
How do I change the thickness of a bottom boarder in Excel 2002?	Dawn	Excel Discussion (Misc queries)	12	January 14th 05 04:50 PM
In Excel 2000, can I change the direction of the move selection a.	GTP	Excel Discussion (Misc queries)	2	January 7th 05 01:20 AM

All times are GMT +1. The time now is 05:24 PM.

Menu

About Us