/csv/prices in excel showing decimal values as a large number
Apologies if this is a known issue and an solution exists.
I am using Msoft excel to import the /csv/prices data. It seems to me that a decimal price value is arriving as a x10^11 to x10^16 number. The number size seems to vary as the decimal number changes in the prices, so I cannot compensate for it reliably.