asked on

MS Excel Formula Result not displayed

Hello,
This is so strange and I can't see what the problem is. I am sure it has a very simple solution.
And the cell format is the same.

Column J does not want to show the TRUE or FALSE, as does I;

SOLUTION

Naresh Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Glenn Ray

Column J is probably formatted as Text; change the cell(s) or entire column to "General" then press [F2] and [Enter] on that first cell in J1.

-Glenn

SOLUTION

duncanb7

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chima

ASKER

Hello everyone, while duncanb7's solution worked in one column, for whatever the reason does not work on other columns. I have looked at all of the cell's formatting and this does not solve the problem totally.
To add more clarification to the origin of this problem; the content of this Excel file comes from the conversion of a pdf to txt, then opened with Excel to form the xlsx file. I suspect that through all of the conversions the content got corrupt.
This issue is not all that important for me solve at this time, so I am tabling the problem, but issuing the points shortly.
Thank you all for the help.

chima

ASKER

Thanks

duncanb7

Thx for your ot

Have a nice day

Duncan