| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text data being converted to Scientic Notation
I am loading an HTML table. One of the columns is a list of 4 character
department numbers. A valid department number could be 83E1, but when I open the HTML table file in excel, any department that has a standing E in the 2nd or 3rd character of numbers get interpreted as being scientific notation and is converted (8.30+E2). I want Excel to IGNORE this conversion! And I can't simply get it back to 83E1, because if I make 8.30+E2 a text column, it converts that number to the string 830. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem working with time data imported from text file | Excel Worksheet Functions | |||
| In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
| How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) | |||
| Bar Chart for Text Data | Charts and Charting in Excel | |||
Threaded Mode
