Views price format for Google merchant
How do I get the pricing in the right format for google merchant using views, or should I use something else?
As I see it Google wants a price in the format '250.00 USD'.
The issue I have is I can use Commerce Produce:Price and then select Raw amount and rewrite the result using [commerce_price-amount] [commerce_price-currency_code], giving me '25000 USD', but I can't get it to include the decimal point without switching to Formatted amount which then includes the $ sign at the beginning.
I have seen the Commerce Google Merchant Integration module but take up is really low so I assumed a view was the more popular way.
All help appreciated