I exported by Inventory library but it did not provide me with the total values. Where is a report that will calculate this for me? Also, the prices were exported as text and I have to convert them one by one to get them into number format. I must be missing something.

Exporting the item inventory list will not provide you with totals other then how many of each item you have on hand. 

You will have to add your own formulas to calculate total inventory dollars. 

By selecting the whole column you can adjust the format of all cells in the column.