[tennisnut]

I need to keep the formatting from excel where each number may have a
different number of decimal points and or currency symbol, so field switches
are not helpful, at least not the ones I've come across. I have tried using
the confirm file format conversion on open, as suggested by microsoft. This
does not work if you have multiple worksheets, it only picks the first one.

Any ideas?