Import large number string
 

I have a .csv file which has a column contain big tracking number. When I
open this file with Excel. The numbers become scientific notation.
To avoid this, I put a single quote before the numbers. Now the excel show
the numbers as string. However, the single quote is there too and need move
in/out of the cell to hide the single quote.

My questions a
1. Is there any way to import a large number?
2. Is there any way to hide all single quote in one click.

thanks

Import large number string
 

Rename the .csv file to .txt and when you use file|open, you'll see the text to
columns wizard.

You'll be able to specify that that long numeric field is text.

Or keep the .csv file extension and use:
Data|import external data|import data (xl2003 menus)

You'll see that same text to columns wizard.



ying06 wrote:

I have a .csv file which has a column contain big tracking number. When I
open this file with Excel. The numbers become scientific notation.
To avoid this, I put a single quote before the numbers. Now the excel show
the numbers as string. However, the single quote is there too and need move
in/out of the cell to hide the single quote.

My questions a
1. Is there any way to import a large number?
2. Is there any way to hide all single quote in one click.

thanks

--

Dave Peterson