| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count number of digits in a cell
Format your cells as 00000000000000
"Julieeeee" wrote: I have a column of numbers that all need to be 14 digits long. So I need to add leading zeros... Currently I am doing =00&A4 and that would be great if they were all 12 digits (12 + 00 = 14 digits) but some are 7, 8, 9, 10, and 11 digits. Is there a formula to count the number of digits in the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New numbers | Excel Worksheet Functions | |||
| count a number range and a letter in a cell | Excel Worksheet Functions | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
| Count number of values in a cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Hybrid Mode
