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.
Format/Cells/Special, then click the OK button.
Is it a good idea to select 'phone number' before clicking the OK button? ;O)
Probably. LOL.Actually (at least in Excel XP) if you leave a space between the area code and the number, like0208 999999Excel will display the leading 0.
.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.
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
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.
iMac Pro review
Illustrator Charles Williams on how to create magazines and book covers
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.