Hi,



This probably simple to most so hope someone can help me please.

The formula is =a1=b1, expect return =true as has the same value, but returns = False

i.e: =5000=5000=False.

I understand it may be text against a number issue, how can i resolve this using a formula & without having to change the data source.

Many thanks,

Haha

Try:
=--A1=--B1

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]