| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data imported into EXCEL as text displayed as exponential number
I am importing a file which I can define (in the exporting application) as either .txt or .cs
One of the fields on the file contains a telephone number(eg 411618720426) , which in some cases is displayed as an exponential number (eg 4.11619E+11). I want the field as text. Other fields in the same column contain spaces and hyphens. These are treated correctly I also want the process to be automatic without having to manipulate the first field etc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert an imported number to text | Excel Worksheet Functions | |||
| Converting imported cell from exponential form | Excel Worksheet Functions | |||
| exponential into text or number | Excel Discussion (Misc queries) | |||
| saving exponential to text data | Setting up and Configuration of Excel | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
