View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
1stcoast
 
Posts: n/a
Default My formulas return the formula not a result in the cell

Cell A1
Formula in cell B1
00-1-36000-21800 SPPNT HUGGIES GOODNITES =LEFT(A2,16)

The calculation returns the formula not a result. What am I doing wrong?