View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ying06 ying06 is offline
external usenet poster
 
Posts: 1
Default 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