| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to pre-format cells to text when exporting data to csv or x
I frequently have to export data from an ERP to excel. I can export as csv or
txt and have to manually intervene to change xecel cell format to text so that the leading zero's aren't lost. I want to automate this process. How (if at all) can excel be pre-formatted to always open in text format to prevent the leading zero's been lost? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
| Do a calculation in cells with text data format | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Linear Mode
