How to make a cell to match another cell

Hey everyone

how can i tell excel that if i change a text for example 1 to A , it also changes the number 1 in another cell to A?

i have attached my spreadsheet so you can understand what i mean. if you change the display value from 1 to A , everything changes which is perfect but in the last table the value which contains the numbers does not change from 1 to A !

could someone plz help me with this?



thanks.

Originally Posted by gak67

To change the 1's to A's, do a replace (Ctrl+H). Find 1 (Options - Match entire cell contents), and replace with A, Replace All.

thanks for your reply but it is not what i what i want is that when i change 1 to A in my cell, every other cells which contains 1 automatically changes to A. this happens to all my tables expect for the last one.