excel text formula does not calculate after editing
I have a simple formula =A16&","&TEXT(ROUND(e16,2),"0.00")
and it works very well and I've used that and variations extensively. If I
copy to another cell it works well. Now however when I try to type the
formula into a cell or edit it after I've copied it all I get is the formula
displayed - not the result.
Help, LK
|