Hi, seems to be 99% working.. works this situation as column is a calculated
field (non-issue in a text column with cond. formatting referring to other
items? as would not occur?),

the thing I see as very odd is that procedure added a +0 (plus zero)
directly to the end of my long equation. For now will assume that is ok / is
the ultimate fix/ answer...

"Biff" wrote:

Hi!

U14 is probably TEXT. It can still be TEXT even though FormatCells is set
to NUMBER.

Try this:

=ISTEXT(U14)
=ISNUMBER(U14)

Select an empty cell. Make sure this cell has not been preformatted and its
format is the default GENERAL.
Goto EditCopy
Select cell U14
Goto EditPaste SpecialAdd
OK

Did that straighten things out?

Biff

"nastech" wrote in message
...
Hi, don't know what is wrong, small question?? ugh
have equations involved, but simple version also shows as in same cell:

170<186,000 comes up TRUE

but when have in separate cells: 170 in U14 & 186000 in U15
=U14<U15 comes up FALSE

=U14U15 comes up TRUE cannot figure out problem

(right click all cells format: number, same each / paste formats over
each
other, no change...)