Forum Discussion

TannerCreamer's avatar
TannerCreamer
Occasional Reader
Mar 04, 2026

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

 

excel

2 Replies

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Mar 05, 2026

    HelloTannerCreamer​, Use this formula in A1 and drag down: ="Item "&MID(TEXT(ROW(A1)/1000,"0.000"),2,5)&"."&MID(TEXT(ROW(A1)/1000,"0.000"),2,5) This produces Item .001.001, Item .002.002, Item .003.003 with text in front.

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Mar 05, 2026

    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