View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Function =c25=c49

Text versus number, hidden spaces etc

try

=LEN(cell)

on both, if they have the same number then it must be different format


Regards,

Peo Sjoblom


"dwoloszyk" wrote:

I am using the function (=c25=c49) to return a true or false. The columns I
am comparing in excel are the exact same amount, but the value being returned
is FALSE.
What would cause this?