If you're on the instant release metformin, that tends to cause more gastrointestinal distress than the extended release. Perhaps try giving the extended release version of metformin a try, and see how that treats you.

I can totally empathize with you on that, I was on 2000 mg metformin and it was like anything I put in me went straight through me... it was awful. I had to get off of it.