Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exact length of the cell
I need to add a leading 0 if the length of the text is less than 10 char
Example: I have in A1 34126 so I need to 5 leading 0s in front or 96750004 -so I need to add 2 leading 0s in front What is the way to do it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
exact length of the cell
Use a custom number format of: 0000000000
FormatCellsNumber tabCustom Below "Type:" enter 10 zeros OK -- Biff Microsoft Excel MVP "sabi0398" wrote in message ... I need to add a leading 0 if the length of the text is less than 10 char Example: I have in A1 34126 so I need to 5 leading 0s in front or 96750004 -so I need to add 2 leading 0s in front What is the way to do it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
exact length of the cell
Format Cells... Custom 0000000000
-- Gary''s Student - gsnu200808 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
exact length of the cell
sabi,
Note that formatting the cells will not change the actual length of the string, just how it is displayed. Use = TEXT(A1,"0000000000") if you need the actual length to be 10 - copy the formula and paste down to match your data. You can also copy those formula and paste values over the original data if that is required. HTH, Bernie MS Excel MVP "sabi0398" wrote in message ... I need to add a leading 0 if the length of the text is less than 10 char Example: I have in A1 34126 so I need to 5 leading 0s in front or 96750004 -so I need to add 2 leading 0s in front What is the way to do it? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
exact length of the cell
in B1 put this formula
=LEFT(A1*1&TEXT(R19,"0000000000"),10) On Oct 17, 9:56*pm, sabi0398 wrote: I need to add a leading 0 if the length of the text is less than 10 char Example: *I have in A1 34126 so I need to 5 leading 0s in front or 96750004 -so I need to add 2 leading 0s in front What is the way to do it? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
exact length of the cell
sorry
=Text(A1,"0000000000") On Oct 17, 10:17*pm, muddan madhu wrote: in B1 put this formula =LEFT(A1*1&TEXT(R19,"0000000000"),10) On Oct 17, 9:56*pm, sabi0398 wrote: I need to add a leading 0 if the length of the text is less than 10 char Example: *I have in A1 34126 so I need to 5 leading 0s in front or 96750004 -so I need to add 2 leading 0s in front What is the way to do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
exact percentage of each cell | Excel Worksheet Functions | |||
How to paste exact value into another cell? | Excel Worksheet Functions | |||
Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
Extracting an exact phrase from a Cell | Excel Discussion (Misc queries) |