I received a report from an Oracle Database (SQL Developer), one of the columns (which was supposedly a currency value, was formatted with a number of leading spaces and was recognised in excel as "general". In the next column I did =trim(B2) to cut out the leading spaces, and then I just copied and pasted values and number formats, which gave me the values with no leading or trailing spaces. I then highlighted the entire column and tried to format as "currency", this did that but then created an error against every cell in that column. I tried to import this data into access, and selected that column as currency, but I get an import error for practically every cell. How can I get excel (and then ultimately access) to recognise these cells as true currency values, so next time I import to access it imports them fine?