View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default formula remian in cell

Hi,

If it's a single column then it's a fair bet the cell was formatted as text
before the formula was entered. Re-format as 'general' with the cell selected
tap F2 and enter.

Mike


"Dylan @ UAFC" wrote:

I have one column in work sheet were the formula shows in the
cell and will not go away

waht can i do