Changing cell format from text to currency
 

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

Changing cell format from text to currency
 

Should add its Excel 2007



"RFJ" wrote in message
...
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

Changing cell format from text to currency
 

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

"RFJ" wrote:

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