How do I insert a leading zero?
 

Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.

How do I insert a leading zero?
 

Phil

If they are preformatted as text, use a new column and enter

="0"&C1

and copy it down. If you want to replace the old values, just copy the new
ones and editpaste special...values the new over the old

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Phil" wrote in message
...
Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.

How do I insert a leading zero?
 

Select the cells and then pull-down:

Format Cells Number Custom and enter "0"General
--
Gary's Student


"Phil" wrote:

Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.

How do I insert a leading zero?
 

Hi Nick,

I tried that, and it didn't work.

My cell for instance, is C639, contains the value: 301229650, which is
preformatted for text. When I go to the next col. D, I type in ="0"&C639.
But all it shows is the formula. Am I missing something?

"Nick Hodge" wrote:

Phil

If they are preformatted as text, use a new column and enter

="0"&C1

and copy it down. If you want to replace the old values, just copy the new
ones and editpaste special...values the new over the old

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Phil" wrote in message
...
Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.

How do I insert a leading zero?
 

Phil

Column D is most likely also formatted as text.

Re-format to General then re-enter the formula and drag/copy down.

OR hit CTRL + `(back quote) to turn off "Formula View"


Gord Dibben Excel MVP


On Sun, 23 Oct 2005 15:58:02 -0700, "Phil"
wrote:

Hi Nick,

I tried that, and it didn't work.

My cell for instance, is C639, contains the value: 301229650, which is
preformatted for text. When I go to the next col. D, I type in ="0"&C639.
But all it shows is the formula. Am I missing something?

"Nick Hodge" wrote:

Phil

If they are preformatted as text, use a new column and enter

="0"&C1

and copy it down. If you want to replace the old values, just copy the new
ones and editpaste special...values the new over the old

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Phil" wrote in message
...
Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.

How do I insert a leading zero?
 

Hello Gord,

You were right. I apprieciated your input.

Thank You.

"Gord Dibben" wrote:

Phil

Column D is most likely also formatted as text.

Re-format to General then re-enter the formula and drag/copy down.

OR hit CTRL + `(back quote) to turn off "Formula View"


Gord Dibben Excel MVP


On Sun, 23 Oct 2005 15:58:02 -0700, "Phil"
wrote:

Hi Nick,

I tried that, and it didn't work.

My cell for instance, is C639, contains the value: 301229650, which is
preformatted for text. When I go to the next col. D, I type in ="0"&C639.
But all it shows is the formula. Am I missing something?

"Nick Hodge" wrote:

Phil

If they are preformatted as text, use a new column and enter

="0"&C1

and copy it down. If you want to replace the old values, just copy the new
ones and editpaste special...values the new over the old

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Phil" wrote in message
...
Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.

How do I insert a leading zero?
 

Hi Nick,

After reading Gord's reply below I realized that he was right. I changed the
format, and it worked great after that.

I apprieciate your input.

Thank You.

"Nick Hodge" wrote:

Phil

If they are preformatted as text, use a new column and enter

="0"&C1

and copy it down. If you want to replace the old values, just copy the new
ones and editpaste special...values the new over the old

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Phil" wrote in message
...
Hello,


I have some text values (in Col C) that need 1 (one) leading zero put in:

I have some text values below:

306445854
250641222

which I want to look like:

0306445854
0250641222

How do I do this?

TIA for your replies.

Phil.