Creating zero's in front of number and after number

[dyukon]

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!

 

[Niek Otten]

Format>Cells>Number 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"

 

[Bernard Liengme]

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

 

[CLR]

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