Formatting Issues

C

cware

I'm extracting information from our accounting software into excel. When I
do, there are codes representing a person like SEP1, SEP2...

When these are dumped into excel, they are changing to 1-September, which
really messes up my data. I tried extracting to a saved sheet, with that
column formatted to Text, but that doesn't change a thing.

Does anybody have any ideas on how to either correct this issue or get
around it?

Thank you very much
 
L

Luke M

What tool are you using to extract the data? Based on your trial with the
saved sheet, it sounds like the data is coming in as a non-text format, or at
least in some manner that is changing the format of the cells in XL.

Depending on the extraction tool, you may be able to change a setting there
that will force the data to dump into XL and preserve the text format.
 
C

cware

Looks like my system dumps out first as XLS, (it looks like XL though..), but
if i try to save the file, i have to change the type from Text(tab delimited)
to Microsoft Excel 97-Excel 2003 & 5.0/95 Workbook. Is there a way to change
what my system sees when it brings up the Text(tab delimited) format?

Thanks
 
Top