Conversions

[it's an excel world]

Hi all,

I have several location numbers set up at my place of work with a prefix of 1E. They are generally along the lines of 1E001, 1E002, etc. When these locations are exported into Excel, I'm sure you can guess what happens. I lose the actual location number and am left with what appears to be scientific or engineering conversions such as 1.00E+9. Is there a way to prevent this from happening or a method to adjust them back to their actual value?

Thanks in advance!

 

[VoG]

Try formatting the cells as Text before exporting.

 

[it's an excel world]

I am not able to format them to text prior to the export. They export into a newly opened file each time.

 

[VoG]

If the export is controlled from Excel then that should be possible.