Hi,

I'm creating a query in Excel from my AS/400 server. It's working fine but i
need to do some changes! (i'm doing them manually but don't like that...)
1 - the date comes like "10207" when i want "01/02/07"
2 - all the values in my sheet need to be / by 1000
Question: where can i setup these things? in the query? in VBA? and how......

hope that someone can help me.
Thanks,
Barbara