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

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