| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
