Sorry for the misstatement! The display of the formula rather than the result is not because I added &"". I copied the original formula into a new blank cell, modified it and got the result that I wanted. I'm not sure if the problem is related to the worksheet password protection or something else.