Hi Koba,

Select the 'Find entire cells only' option.


---
Regards,
Norman


"koba" wrote in message
...

Hello Everyone


When i highlight a colum and use the replace fuction how do i replace
the whole number 4 with the number 2, because currently it replaces all
the number in everything such as the cell that has 48 goes to 28?

Please help

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile:
http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=487831