Peo Sjoblom wrote:
I agree that it is annoying. You can convert multiple cells by copying an
empty cell (preferably preformatted with the number format you want), then
select all the imports and do editpaste special and select add. You could
obviously do this and record a macro and run this macro whenever you import
data

Two issues:

When porting from SSIS, there could be an issue about it not putting the
data in the right spot if there's anything in the fields. I'm not
talking about values, but possibly formatting. I've ported data over,
then deleted the data (by cell range, not by deleting rows), and when it
ported the next bank of data, it did it below where the first bank was,
even though the cells were "empty". Not sure what it doesn't like.

Next issue is, it's supposed to be an automated report, and the client I
send it to doesn't want to have to run macros to bring things up to
snuff. They might have a company policy about disabling macros when
opening up a file.

So, not sure what to do.

I guess the other thing I could do, and it's really kludgy, is to
reference the text numbers by yet another worksheet. The "=" formula
will convert for me, then run my graphs off the reference worksheet.
This gets really unwieldy visually though, unless I hide worksheets.