Changing cell format from text to currency

R

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert number to text as displayed 3
Format Currency in-cell 2
If statement based on currency format 8
Currency format 8
Sort Not Working on Column of Numbers 4
Formula for Detecting Currency Format 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Can Not get cell to accept any format change! Source from html 1

Top