I am importing currency from Google finance to Google spreadsheets (latest version). The number that is imported is rounded both in terms of what is displayed and the underlying number. Is there a way to get the actual underlying currency number to all necessary decimal places?
I used the external lookup - =ImportHTML("http://www.xe.com","table", 1)
in a unused part of the spreadsheet and then sourced the appropriate rate from the table contents. Will probably work with other currencies too - look at xe.com Updates every minute which is fine for my purposes.