| 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? |
| 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) | |||
Threaded Mode
