software

I need to create zero's in front of number and after number. For
example if the value is 12500. I need to have it look like
000012500000. Please help!--
dyukon
------------------------------------------------------------------------
dyukon's Profile: www.excelforum.com/member.php...oamp;userid=30062
View this thread: www.excelforum.com/showthread...hreadid=500660Formatgt;Cellsgt;Number tab,Custom. In the Type box, enter:

000000000quot;000quot;

Does the number of digits vary? Is it always 4 zeros in front and 3 at the
end? Can it be a text field?
Try a formula, like

=quot;0000quot;amp;TEXT(A1,quot;0quot;)amp;quot;00quot;--
Kind regards,

Niek Ottenquot;dyukonquot; gt; wrote in
message ...
gt;
gt; I need to create zero's in front of number and after number. For
gt; example if the value is 12500. I need to have it look like
gt; 000012500000. Please help!
gt;
gt;
gt; --
gt; dyukon
gt; ------------------------------------------------------------------------
gt; dyukon's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30062
gt; View this thread: www.excelforum.com/showthread...hreadid=500660
gt;
With a custom format like 0000000000 you can add leading zeros but not
trailing ones
That needs a formula such as =TEXT(A1*1000,quot;0000000000000quot;)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;dyukonquot; gt; wrote in
message ...
gt;
gt; I need to create zero's in front of number and after number. For
gt; example if the value is 12500. I need to have it look like
gt; 000012500000. Please help!
gt;
gt;
gt; --
gt; dyukon
gt; ------------------------------------------------------------------------
gt; dyukon's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30062
gt; View this thread: www.excelforum.com/showthread...hreadid=500660
gt;
If you are entering the data by hand, simply pre-format the cell(s) as TEXT,
or type a preceeding apostrophe before the data

Vaya con Dios,
Chuck, CABGx3quot;dyukonquot; wrote:

gt;
gt; I need to create zero's in front of number and after number. For
gt; example if the value is 12500. I need to have it look like
gt; 000012500000. Please help!
gt;
gt;
gt; --
gt; dyukon
gt; ------------------------------------------------------------------------
gt; dyukon's Profile: www.excelforum.com/member.php...oamp;userid=30062
gt; View this thread: www.excelforum.com/showthread...hreadid=500660
gt;
gt;