Cell Showing Formula, not Result
Cell Showing Formula, not Result
(OP)
Hi,
I have a small question:
In a worksheet that prepared by others, I want to put a formula in a cell. But when I put there, I see just formula and not result of formula?!
To let you know,other part of worksheet is only Text.
Thanks
I have a small question:
In a worksheet that prepared by others, I want to put a formula in a cell. But when I put there, I see just formula and not result of formula?!
To let you know,other part of worksheet is only Text.
Thanks





RE: Cell Showing Formula, not Result
TTFN
RE: Cell Showing Formula, not Result
RE: Cell Showing Formula, not Result
Yes, there is = ahead of formula.
I changed cell property to number.
But they didn't work!
RE: Cell Showing Formula, not Result
RE: Cell Showing Formula, not Result
RE: Cell Showing Formula, not Result
Regards,
Brian
RE: Cell Showing Formula, not Result
For example, entering =2+3 will show 5 but entering '=2+3 will show =2+3
RE: Cell Showing Formula, not Result
RE: Cell Showing Formula, not Result
You solved my problem.