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