I
I
Ilya Borisenko2019-10-05 16:33:12
excel
Ilya Borisenko, 2019-10-05 16:33:12

How to autofill a series of numbers of this type in Excel: "1."?

How to autofill a series of numbers of this type in Excel: "1."? There should be a similar sequence:
1.
2.
3.
...
Each digit is a separate cell.
Excel stubbornly refuses to extend the row as it should.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
J
John Smith, 2019-10-07
@lilovij

Ilya Borisenko , It is
more logical to make a series of numbers without a dot, and add the dot in the cell format by writing a string in the custom format
Then the number will be stored in the cell, and the number with a dot will be displayed.
5d98f8b95b854072977692.png

Y
y0u, 2019-10-05
@y0u

=ROW()&"."

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question