Numbers Spreadsheet not recognising values so formula SUM is not working
Hi hope someone can help.
Numbers Spreadsheet - Not recognising values so basic sum formula does not work. I have changed the formatting of the cells and this has not helped. I have changed the language and region and this has not helped. I have multiple tabs on this spreadsheet and half the tabs work and the other do not?? The information was original downloaded from a Santander bank through Excell and cut and pasted into numbers. What I have found is the value in the cell looks different. In the other tabs it will £6.00 for example and in the tabs that are not working it will be £ 6.00. As I say re-formatting these under currency or numbers still makes no change & the £ GAP still remains.
Please help.
MacBook Air 13″, macOS 12.0