ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Suddenly cells are wrong (https://www.excelbanter.com/excel-discussion-misc-queries/85548-suddenly-cells-wrong.html)

PaulW

Suddenly cells are wrong
 
I have done a concatenate() of the total and the percentage so it looks like
256 / 23%
On another sheet I put a link to this cell, by simply going = then clicking
on the cell.
The formula in the forumla bar is also in the formula cell, rather than
where its pointing. It looks like this cell is in formula auditing mode, i've
even tried turning this option on an off, but to no avail.
Any ideas?


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com