software

I have a list on Text data
ie 1, 14, 203, etc
I want them all to be 6 charcters long.
ie 000001, 000014, 000203, etc.
I can concatenate but the I would manually need to remove extra 0's Any
suggestions

--
Thanks
ETC

Set the format to 000000 (Formatgt;Cellsgt;Custom)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Sweetetcquot; gt; wrote in message
...
gt; I have a list on Text data
gt; ie 1, 14, 203, etc
gt; I want them all to be 6 charcters long.
gt; ie 000001, 000014, 000203, etc.
gt; I can concatenate but the I would manually need to remove extra 0's Any
gt; suggestions
gt;
gt; --
gt; Thanks
gt; ETC
If it is for display purposes, you can format (numbers, not text) using a
custom format of quot;000000quot;

If you need the values to 6 characters you can use for numeric values:
=text(number, quot;000000quot;)

For text values:
=rept(quot;0quot;,6-len(text value))amp;text valuequot;Sweetetcquot; wrote:

gt; I have a list on Text data
gt; ie 1, 14, 203, etc
gt; I want them all to be 6 charcters long.
gt; ie 000001, 000014, 000203, etc.
gt; I can concatenate but the I would manually need to remove extra 0's Any
gt; suggestions
gt;
gt; --
gt; Thanks
gt; ETC

Format gt; Cells... gt; Number gt; Custom and enter 000000
--
Gary's Studentquot;Sweetetcquot; wrote:

gt; I have a list on Text data
gt; ie 1, 14, 203, etc
gt; I want them all to be 6 charcters long.
gt; ie 000001, 000014, 000203, etc.
gt; I can concatenate but the I would manually need to remove extra 0's Any
gt; suggestions
gt;
gt; --
gt; Thanks
gt; ETC

Duke

Thanks the TXT seemed to do the trick. I could not get the REPT to work
correctly
--
Thanks
ETCquot;Duke Careyquot; wrote:

gt; If it is for display purposes, you can format (numbers, not text) using a
gt; custom format of quot;000000quot;
gt;
gt; If you need the values to 6 characters you can use for numeric values:
gt; =text(number, quot;000000quot;)
gt;
gt; For text values:
gt; =rept(quot;0quot;,6-len(text value))amp;text value
gt;
gt;
gt; quot;Sweetetcquot; wrote:
gt;
gt; gt; I have a list on Text data
gt; gt; ie 1, 14, 203, etc
gt; gt; I want them all to be 6 charcters long.
gt; gt; ie 000001, 000014, 000203, etc.
gt; gt; I can concatenate but the I would manually need to remove extra 0's Any
gt; gt; suggestions
gt; gt;
gt; gt; --
gt; gt; Thanks
gt; gt; ETC