Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Limitation on MID function? - very large string | Excel Worksheet Functions | |||
LARGE with text string | Excel Worksheet Functions | |||
LARGE IMPORT | Excel Worksheet Functions | |||
how do I import a large amount of text into one cell? | Excel Discussion (Misc queries) |