Setting Weight Unit to grams for e-commerce csv file import

I really really need to set the weight unit to grams in my csv files. I have thousands of products to import. I have tried grams, Grams, g, G and ” g” (without the quotes) but nothing works.

When I view the product in the product list (in admin), it says 0.7g with no space. The ones I’ve manually set say 0.7 g
When I go in to edit the test product, I see that it’s set at 0.7 Pounds.

Is there something I do to the excel file to make it keep the space?
I’m thinking ” g” would work if I could get it not to ignore the space, but I don’t know that’s even the issue. Any advice? Surely someone has had to do this before. Thank you so much!!!