Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Download/Import from Tab Delimited - Formatting of Data
My office does a download from a mainframe application to get data into
Excel. The data is put into a tab delimited and this the file Excel reads for the import/download. Quite of bit of the data is financial data which contains leading zeroes. Currently, to preserve the leading zeroes, we put an apostrophe at the front of each field (in the tab delimited file, so this is how it opens in Excel). Is there a way to send it the data to Excel all as text so that the leading zeroes will be preserved without having to use an apostrophe? Thanks for your thoughts/help/comments! Ashley |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Delimited File | Excel Discussion (Misc queries) | |||
Tab delimited ? text import | Excel Discussion (Misc queries) | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
how do I import tab delimited data? | Excel Worksheet Functions | |||
how do Import data tab delimited text? | Excel Worksheet Functions |