View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lannyk lannyk is offline
external usenet poster
 
Posts: 2
Default 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