B
Bernard Purdon
Hello
My problem is when I download data from Accounting Software to Excel.
The data is in British Pounds, and when downloaded to Excel each number has
a symbol attached to it (e.g. ï½£414.90). With this symbol in front of each
number, I am unable to perform forumlas on the data (Excel is not accepting
the data as numerical). I need a way of removing the symbol from each
number.
I can delete the symbol manually from each number, however, it is a long
process.
Is there a function in Excel that removes a symbol?
Any help would be appreciated
Regards,
Bernard Purdon
My problem is when I download data from Accounting Software to Excel.
The data is in British Pounds, and when downloaded to Excel each number has
a symbol attached to it (e.g. ï½£414.90). With this symbol in front of each
number, I am unable to perform forumlas on the data (Excel is not accepting
the data as numerical). I need a way of removing the symbol from each
number.
I can delete the symbol manually from each number, however, it is a long
process.
Is there a function in Excel that removes a symbol?
Any help would be appreciated
Regards,
Bernard Purdon