One method to convert text to numbers is by multiplying by 1

1. Enter 1 in any unused cell.
2. Select the cell and copy (Control-C)
3. Highlight the cells which are to be converted to numbers.
4. Click on Edit/PasteSpecial and select multiply.

Alok

"RjS, CISSP" wrote:

Thanks much Bob

1. how do you tell if there is mixed text and numbers?

2. how would I reformat for all numbers if there is text imbedded? I tried
changing the cell category and also copying and paste special - values only,
but that didnt seem to do anything either.

3. I tried your suggestion and changed the CF to "Formula Is =--J8<0" but
the cell with a negative value in it still does not format properly. Any
other suggestions?

Regards-

"Bob Phillips" wrote:

You probably have text in the data.

You can either reformat, or change your CF to a formula, like =--A2<0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RjS, CISSP" wrote in message
...
Hi Folks
I have a financial spreadsheet that was created from a webpage by
importing
the data. Data seems to have imported OK and cells are correctly formatted
at
"Currency". But when I apply a CF of Cell value is less than 0, and the
cell
contains a minus number, it absolutely ignores it. In fact, if I apply a
CF
of Cell Value is Greater Than 0, and the cell contains a MINUS number, the
CF
returns true and applies the CF formatting.

Any Suggestions?

Thanks in advance.