| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting and adding
I wanted to know if there is a formula that counts the number of digits in a
cell then adds zeroes until there are 6 digits. For example, 1238 37830 38 782 628918 With formula would look like: 123800 378300 380000 782000 628918 Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting and adding | Excel Discussion (Misc queries) | |||
| adding totals in a column, not counting repetitions in another col | Excel Discussion (Misc queries) | |||
| Counting | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Threaded Mode
