Excel 2007 : Replace and Look In Values

[nucleotide_boy]

Hi,

I'm using Office 2007. I've got a new occuring problem which is really irritating me.

I want to use the replace box as usual to replace a load of values with something else. However, when I open up the replace box it will only let me look in formulas. It doesn't list anything else for the look in option. This is not the case with the simple find box however. What on earth is going on?

[nucleotide_boy]

*bump for response*