Proper formula

[Sands]

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) I have a product list that was typed in uppercase I used the proper formula to change this. I now need to edit the new list but it just gives me the formula not he text in the cell.

Have tried formatting cells to txt. Any ideas?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

I have a product list that was typed in uppercase I used the proper formula
to change this. I now need to edit the new list but it just gives me the
formula not he text in the cell. <br><br>Have tried formatting cells to txt.
Any ideas?

Copy the cells with the formulae, then use Paste Special/Values to paste
it into either the same cells or others.

 

[Sands]

Arh thank you I will try this.. I did, however, copy it to word and paste it back in which also worked.. but I was sure there must have been a way to do it in excel

 

[Sands]

Much better thanks so much