There's a couple of ways
1). Format cell as text
2). Enter a ' before text
3). Format cell as "0"General
4). If a mobile Number leave a gap 07777 777777
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread:
http://www.excelforum.com/showthread...hreadid=565627