I am trying to create text files that are as close to completely formatted for EXCEL as I can get. I'm creating these files on a UNIX/BBx-Basic machine. I'd like to be able to embed something in the file to tell it that the field is TEXT instead of GENERAL.
I thought that the Text Qualifier might enable this. I must be wrong. So, what is this for?
Is there a way to create a file the way I want?
I need this so the users don't have to go to each of the many columns and specify TEXT. The file names are always different so I don't know how to make a macro for this. Obviously, EXCEL is not my specialty!
Thank you.
I thought that the Text Qualifier might enable this. I must be wrong. So, what is this for?
Is there a way to create a file the way I want?
I need this so the users don't have to go to each of the many columns and specify TEXT. The file names are always different so I don't know how to make a macro for this. Obviously, EXCEL is not my specialty!
Thank you.