Home Forums Tech Helproom Excel problem Forum Rules | Contact Forum Editor | Report a Post Excel problem gudda96 17:34 14 Aug 2003 Locked Hi GangWhen I type a tel no in an Excel cell eg 0208the first 0 does not stay.I know it is something like format/custom etc but have forgotten, can you help. Peter 18:31 14 Aug 2003 .You could just enter the number preceding it with a single quote e.g '020 899 9999 or use the BT prefered layout of (020) 899 9999.Peter. Simsy 18:45 14 Aug 2003 and it orks as VoG suggests.. i.e. if you enter a number leaving a space somewhere, such as;020 8888 8888It keeps the leading zero.If you don't have a space it thinks it is just a "number" and removes it.Alternatively, you could format the cell as "text"Good luck,Regards,Simsy gudda96 08:47 15 Aug 2003 SimsyYou are correct, just received this and it works, thanks everyone.format>cells>number>text. This thread is now locked and can not be replied to.