telephone number

boscombescouts · Joined: 20 Oct 2009 Posts: 1

I was just wondering whether you could change the telephone number field formats to be text instead of number as it will not let me put in a number that begins with '0' ie 07*** ******

I know I could always put in +44 but not many people use that nowadays and even if you were going abroad if it was text then you could still enter it as +44......

By the way, brilliant piece of programming - invaluable!!

Dave

parsonssi · Joined: 20 Apr 2010 Posts: 3

Dave - this was a problem I realised a while ago, but it's easily fixed - just make sure you put the area code in brackets () like you would normally write it. This allows the 0 to stay in place, and personally it also makes the number easier to read and enter into a phone Cool

So an 07 number that would usually end up as "7..." in the wordsheet, would become (07...) ......