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.