View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Why does Concatenate formula show but not produce a cell result?

Format as general or number, select the cell, press F2 and then enter


--


Regards,


Peo Sjoblom



"Tom@WardAir" wrote in message
...
The result shows in the formaula calualtiuon but not in the actual cell.
How
do the result to display in the cell? I have changed formating to all
text,
but I get nothing but formula. Won't calculate for some reason. Help!