Prev: Rounding up/down to .95
Next: excel 2003, list box:
From: Killarney Tom Killarney on 6 Feb 2010 18:23
I have a worksheet containing a column of cells each containing a mobile
phone number - the number in the cell is 7 digit , but needs to be 8 digit
(commencing with a "0" - which is now missing ) I need to insert a 0 at the
front of current string of 7 digits in each cell - I've done this before
but have forgot how to do. Can you pls tell me what formula / instruction I
must use to get a column with desired result - I need the phone number in
correct 8 digit format for a SMS transmission programme.
Many Thanks
Tom
From: Joe User on 6 Feb 2010 18:40
"Killarney Tom" wrote:
> I need to insert a 0 at the
> front of current string of 7 digits in each cell

If the phone numbers are entered as numbers, not text, and you merely want
the cell value to appear as 8 digits with leading zeros, you can use the
Custom format 00000000.

If the phone numbers are text or numbers, and you want want the actual cell
value to be 8 digits, use the following to create 8-digit text:

=TEXT(A1,"00000000")

where A1 contains the original phone number. If you want to replace A1 with
the result of the formula (in B1, say), copy B1 and use paste-special-value
to overwrite A1.


----- original message -----

"Killarney Tom" wrote:
> I have a worksheet containing a column of cells each containing a mobile
> phone number - the number in the cell is 7 digit , but needs to be 8 digit
> (commencing with a "0" - which is now missing ) I need to insert a 0 at the
> front of current string of 7 digits in each cell - I've done this before
> but have forgot how to do. Can you pls tell me what formula / instruction I
> must use to get a column with desired result - I need the phone number in
> correct 8 digit format for a SMS transmission programme.
> Many Thanks
> Tom
 | 
Pages: 1
Prev: Rounding up/down to .95
Next: excel 2003, list box: