Cut & Paste

[Tony]

I'm trying to copy and paste a table of information from a web site into
excel 2002.
All is well except for the transaction numbers.
The web site has a column for transaction numbers.

this is an example of the trans number on website.
24610435075004026439747

This is what is pasted to Excel.
2.4610435075004E+22

and I lose significant digits.
I've tried to format the cells in Excel before I paste and I've tried after
the paste.
I can expand the number but I only 0 after 24610435075004000000 ...
I want to eventually get this into Access Excel is just a way to import
data.

Any help on how to copy that web site table into Excel and maintain the
integrity of the information?

Thanks

 

[spencerchicken]

its just the width of your column, expand your column and all will be
fine

 

[Tony]

Nope that didn't work I expanded it and it maintains the scientific
notation.

 

[Sandy Mann]

Tony,

From the Help File:

· Regardless of the number of digits displayed, Microsoft Excel stores
numbers with up to 15 digits of precision. If a number contains more than 15
significant digits, Microsoft Excel converts the extra digits to zeros (0).

HTH

Sandy

 

[spencerchicken]

I assume that you dont want to use the number for calculations based on
the size of it,
it can be entered in full as text by typing ' before pressing paste

 

[Dave Peterson]

If you paste this number into excel:
24,610,435,075,004,026,439,747
Your going to have trouble.

Excel will handle 15 significant digits (as you said in your post).

If you're only doing one cell's worth of data, you could format the cell as
text, then paste into the formula bar (or type an apostrophe in the formula bar
and paste the number).

Another option that might work for you if you have lots of these numbers.

Paste into Notepad. Save that file as *.txt.
Then use File|open to open that Txt file.
You can specify each field the way you want--including Text. Then you won't
lose those significant digits.

 

[Cyril Deschambeault]

Tony,

If you highlight the cell, right click, format cells, and change the number
from 'general' to 'number' and go to over 22 decimal points, you should see
it.

Let me know if that works.

Cyril