I've been given a spreadsheet where every cell is formatted as text
including some which are currency (eg The contents of cell A4=$25,232.00 -
this includes the dollar sign).

I want to create a formula in another worksheet that looks up cell A4 but
the answer is formatted as currency and I can calculate on it.

Can SKS help

TIA

Rob