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
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