Forum Discussion
TannerCreamer
Mar 04, 2026Occasional Reader
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
m_tarler
Mar 05, 2026Bronze Contributor
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