Forum Discussion
TannerCreamer
Mar 04, 2026Copper Contributor
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
SergeiBaklan
Mar 05, 2026Diamond Contributor
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