Forum Discussion
Solved
Excel Row Pattern
Is there a formula or way I can make multiple decimals continuously adding like so .001.001 .002.002 .003.003 but also have text in front of the 1st decimal
try this:
="TEXT"& LET(s,SEQUENCE(99),n,TEXT(s,"\.000"),n&n)where "TEXT" is the text in front of the 1st decimal and the 99 is the number of lines you want
If without formulae
- type '.001 (as text) in A1
- drag A1 down with Fill Series
- type .001.001 in B1
- stay on B1 and Ctrl+E
- remove column A