Also, if i use auto correct, am i right in assuming that it will be recorded
only in my PC. Will the changes in my autocorrect apply if someone else opens
up this sheet on their PC?

Thanks

"Vin81" wrote:

Thanks pinmaster
However, if I have several data the would need to be replaced. Would there
be any other way of performing this?

cheers
vin

"pinmaster" wrote:


One way.

.....Tools/Auto Correct....replace: 1234 with: Eating Apples


HTH
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=514584