Comment to your post #19



I simply don't know what you are talking about.
In the file attached to post #17 (previous_2) I entered 85. manually in cell A120 and then I entered the formula

=previous+1&"."

in cell A121 and copied this formula down to A126 whereafter these cells contain 86. 87. 88. 89. 90. and 91.

If that's not what you asked for in your original question then you must really explain better.

I think office 2013 gives me like this (using formula =previous+1&".") :





your using office 2016 that's why your trick not working for me (office 2013).