Setting Report number format preference (currency, general, etc...) in QBO

When down loading data from QBO it comes out as custom format and excel doesn't recognise it as currency. How can you down load data so excel can recognise it??