I have never heard of the use of kilo/mega/giga used for standard mass or distance units, either in the media, scientific literature or anywhere else (except kilometer, and kilogram, but kg IS actually the standard unit, not g)
Only place where I've witnessed it's use is during my own personal musings while sitting on the loo. Same goes for money. "Gigadollars" has a nice ring to it but it's not used :(
There are other units of measurement when the numbers get really big, like AU, lightsecond/minute/year, Solar Mass, etc. I'm no scientist, but I also think when you get to the astonomical scale, order-of-magnitude relative measurements is more useful knowing a galaxy's mass to the nearest gram.