My bank sends me my monthly statement as a csv file which I have quite easily copied into excel 2007. I want to be able to use some of the data to assist in producing my annual tax return.
The problem I have it seems the amount's in the 3 columns listed credit , debit and total are not numbers but text. I have tried most of the suggestion's listed on here to convert these columns to currency or accounting but nothing seems to work. Doesn't matter how the cells are formatted nothing changes, Iv copied a cell containing 1 and pasted special multiply to all the cell concerned but the cells refuse to change.
I have attached a small section of the workbook, I just want to be able to do calculations on the cells containing numbers.
Many thanks
Bookmarks