Cell format

E

Esradekan

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
 
R

Ron Rosenfeld

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

You can certainly do a conditional number format depending on the value in the cell; but since your examples all have a leading zero, I'm not sure of the possible range of values.

Also, the numbers you show have 9 or 10 digits, and you write they have 6 or 7. But if you want to input these all as a number, we need to know the possible range of values for those numbers at the beginning that you are not counting.

For example, if there would be a maximum of two digits prior to the six or seven, you could custom format as:

Format/Numbers/Custom Type: [<=99999999]00-000000;00-0000000
 
I

isabelle

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top