You can change format of That column to text and then select column and
Replace(ctrl+H) = signe with blank

"Monty" wrote:

I am importing a bank account statement to a workbook and everything is fine
except for one of the lodgement accounts. the problem with this is that the
name of the account is -GB Cheque. when this is imported the workbook thinks
it is a formula and put this in the cell #NAME?. when i click the cell you
can see the name in the formula box. as i have over 3000 records is there
anyway i can fix this without going through every record and deleting the =
sign.

Any help please.

Monty