trying to apply to cells related to equations using seems to wipe out all
cond. formatting. Is this something I have to do.. / to start over in a
column to verify all cells working? thanks

- cell long equation (cond. formatting refers to.. x) has custom formatting
set:
,,#.0 (for some reason excel changes to: #.0,, )
that is spot where equation is not functioning


"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...)