| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number as string with importing txt file
How to keep the left zero(s) of a string in a cell by importing a simple
text file ? thank you in advance GH |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number as string with importing txt file
Tell the text import wizard to format the column as text.
-- David Biddulph "alfred wallace" wrote in message ... How to keep the left zero(s) of a string in a cell by importing a simple text file ? thank you in advance GH |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
number as string with importing txt file
Don't import the *.txt file.
Open it directly from FileOpen. The Text to Column Wizard will appear and let you choose the formatting of the data as Text Gord Dibben MS Excel MVP On Wed, 16 Apr 2008 22:54:00 +0200, "alfred wallace" wrote: How to keep the left zero(s) of a string in a cell by importing a simple text file ? thank you in advance GH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| counting the number of instances of a string within another string | Excel Worksheet Functions | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| number of fields exceeds 256 when importing from a dbf file | Excel Discussion (Misc queries) | |||
Hybrid Mode
