Changing cell format from text to currency

[RFJ]

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

 

[RFJ]

Should add its Excel 2007

 

[Mike H]

Select your column then

Data|Text to Columns
Select Fixed width
Put a line between the dollar sign and the number
Click Next
Ensure the dollar sign is highlighted and select
Do not import this column
Click finish

Mike