Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding "0" as leading digits into cells in Excel
How can I add "0's" as additional first digits for numbers in a row
containing 4000 random numbers, i.e. change 1346 to become 01346 and 2345 to become 02345... and so forth. If I try "Format cells" and select "Text" I can type the "0" manually cell by cell and it will be displayed with the "0" as the first digit. However if I try to use "Edit" and "Replace" in order to automize the insertion of thousands of "0", it still leaves the "0" out and only displays the number as it was before. I would be greatful for any ideas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding "0" as leading digits into cells in Excel
You can format the cell as Custom 00000
This won't add 1 specific zero, but will work for all 4 digiti numbers So 10 will appear as 00010 and 10,000 as 10000 Steve On Wed, 18 Oct 2006 05:09:01 +0100, Tippetue wrote: How can I add "0's" as additional first digits for numbers in a row containing 4000 random numbers, i.e. change 1346 to become 01346 and 2345 to become 02345... and so forth. If I try "Format cells" and select "Text" I can type the "0" manually cell by cell and it will be displayed with the "0" as the first digit. However if I try to use "Edit" and "Replace" in order to automize the insertion of thousands of "0", it still leaves the "0" out and only displays the number as it was before. I would be greatful for any ideas. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding "0" as leading digits into cells in Excel
If you don't care if they become text...........
In a helper row enter ="0" & cellref Drag/copy across. When happy, select the helper row and copy it. Paste Special(in place)ValueOKEsc. Delete original row. Gord Dibben MS Excel MVP Gord Dibben MS Excel MVP On Tue, 17 Oct 2006 21:09:01 -0700, Tippetue wrote: How can I add "0's" as additional first digits for numbers in a row containing 4000 random numbers, i.e. change 1346 to become 01346 and 2345 to become 02345... and so forth. If I try "Format cells" and select "Text" I can type the "0" manually cell by cell and it will be displayed with the "0" as the first digit. However if I try to use "Edit" and "Replace" in order to automize the insertion of thousands of "0", it still leaves the "0" out and only displays the number as it was before. I would be greatful for any ideas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel hyperlinks to other cells in workbook must be relative | Excel Worksheet Functions | |||
excel is adding cell numbers randomly into other cells | Excel Worksheet Functions | |||
How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |