View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Unable to edit formula

Change cell format to general, it might be text, you might have to go into
editing mode first (first change format, then press F2 then enter)

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Jennifer H" wrote in message
...
I am working in Excel 2000, with a protected worksheet emailed to me from
another co-worker. After unprotecting the worksheet (and workbook), I am
still unable to revise a formula. When I make the revision and press
enter
(or the green checkmark) the formula does not change, but instead appears
in
the cell that the calculation formerly appeared in. How do I make the
revision to the formula?