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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cware" wrote:

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

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"cware" wrote:

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