Creating zero's in front of number and after number
 

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: http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=500660

Creating zero's in front of number and after number
 

FormatCellsNumber tab,Custom. In the Type box, enter:

000000000"000"

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

="0000"&TEXT(A1,"0")&"00"


--
Kind regards,

Niek Otten


"dyukon" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=500660

Creating zero's in front of number and after number
 

With a custom format like 0000000000 you can add leading zeros but not
trailing ones
That needs a formula such as =TEXT(A1*1000,"0000000000000")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dyukon" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=500660

Creating zero's in front of number and after number
 

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, CABGx3


"dyukon" wrote:


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: http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=500660