Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have data that has been pulled in from a query in access and saved as a tab
delimited file. I have then imported it into Excel with the hope of formatting this data into the proper specs for upload to a MainFrame. I want to pad some of the fields with either an empty space or with zeroes. Within Excel I have created a custom filter to accomplish this task. When I export however, I am unable to save the file with the proper formatting (no matter how I save this file). I end up with a tab delimited file instead of being able to combine theses fields with the proper zeroes or spaces. Can anyone help with this? Example: 1-2 record code 3-14 Numeric 15-24 Numeric 25-36 Amount 37-44 Date etc,etc... Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
How do you disable save file dialog? | Setting up and Configuration of Excel | |||
Can't save new excel file | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |