Forum Discussion

TannerCreamer's avatar
TannerCreamer
Copper Contributor
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

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 05, 2026

    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

     

  • 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