| 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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting and adding
=A1*10^(6-LEN(A1))
-- David Biddulph "A.S." wrote in message ... 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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting and adding
Try this:
=A1&REPT(0,6-LEN(A1)) HTH, Paul "A.S." wrote in message ... 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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting and adding
=(A1&REPT(0;6-LEN(A1)))*1
"A.S." skrev: 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, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting and adding
ups forgot it is (,) not (;)
=(A1&REPT(0,6-LEN(A1)))*1 "excelent" skrev: =(A1&REPT(0;6-LEN(A1)))*1 "A.S." skrev: 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, |
| Reply |
| 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) | |||
Linear Mode
