I have a file spooling from Oracle to a format that opens in Excel. Some part numbers are coming in as numbers in advance and then formatting as scientific notation. That's bad enought, but when I format them as text, they stay in that format even theough the cell contents are correct. I can't control the format from the Oracle side, but was wondering what I could do with Excel. I thought maybe there was a way to set the default to text or something in advance, or maybe to develop a VBA routine. In the meantime, I may have to tell the user to do something. Does anyone have any suggestions?
Bookmarks