Hi

After exporting TBS from Pastel to Excel, I routinely use one-column TBs, subtracting the credit column amounts from the debit column ones.

This gives a #VALUE! error so I have to insert zeros in each apparently blank cell.

Find and Replace does not work.

Any ideas?

Thanks