Formatting Cells?

dirty_cofi · May 6th, 2002, 04:19 AM

hey,

Am from the UK which means MS Excels wonderful custom formated cell function for telephne number don't work

The problem is i can't get a formula which will work, i want it to make the number like this (01286) 675-765

Also it does ZIP codes but it doesn;t do PostCodes which is the UK's version of ZIp codes. I need these to be dis[played as LL56 7TY, JJ78 5TY, it is XX77 7XX where x=upper case letter 7=number .

If any one can help that will be amazing cheers.

Later

Chris Davison · May 6th, 2002, 05:34 AM

http://www.mrexcel.com/board/viewtop...c=3743&forum=2

Postcodes may be tricky !

May 6th, 2002, 05:34 AM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	http://www.mrexcel.com/board/viewtop...c=3743&forum=2 Postcodes may be tricky ! __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 04:19 AM	#1
dirty_cofi New Member Join Date: May 2002 Posts: 13	hey, Am from the UK which means MS Excels wonderful custom formated cell function for telephne number don't work The problem is i can't get a formula which will work, i want it to make the number like this (01286) 675-765 Also it does ZIP codes but it doesn;t do PostCodes which is the UK's version of ZIp codes. I need these to be dis[played as LL56 7TY, JJ78 5TY, it is XX77 7XX where x=upper case letter 7=number . If any one can help that will be amazing cheers. Later