I am in need of assistance in removing TEXT on a spreadsheet. I have a credit card report which was downloaded from the bank , however, the numbers are in text format. I made several attempts to change from text to accounting or currency without any success.
I have tried a few things nothing works it appears that the entire sheet in in text format. In each row in this column, the message is "the number in this cell is formatted as text by an apostrophe"
can you some assist me with this matter it is important.