Can someione please assist?

I want to create cell formats using two styles. We have phone numbers
that have 6 numbers and some that have seven numbers. (ie (027-123456
or 026-1234567) and i want to be able to put either in the same
column, rather than have two columns. Is there any way I cam
customise the cells to cater for this so I dont have leading 'zero'
that serves no purpose? I would like to use the phone number as
reference in a vlookup formula.

Using Excel2007

TIA
Esra

hi Esra,

put the cells to custom size "000-000000"
....menu / format / cell / Category / customized
and now typed 12345678

--
isabelle



Le 2011-09-15 18:57, Esradekan a écrit :
> Can someione please assist?
>
> I want to create cell formats using two styles. We have phone numbers
> that have 6 numbers and some that have seven numbers. (ie (027-123456
> or 026-1234567) and i want to be able to put either in the same
> column, rather than have two columns. Is there any way I cam
> customise the cells to cater for this so I dont have leading 'zero'
> that serves no purpose? I would like to use the phone number as
> reference in a vlookup formula.
>
> Using Excel2007
>
> TIA
> Esra

I worked it out from that, thanks very much Ron

Esra

sorry i was outside the trak
(expression of my country)

--
isabelle


Le 2011-09-15 20:15, isabelle a écrit :
> hi Esra,
>
> put the cells to custom size "000-000000"
> ...menu / format / cell / Category / customized
> and now typed 12345678
>