"MAnderson" wrote:
Thanks Max. This did what I wanted it to. The only shortcoming is that if
you add or remove a row in your spreadsheet it doesn't automatically
recalculate; I had to recopy the formula. Maybe you know a way to define the
formula to recalculate?

If you delete a row in-between the filled range, it will recalc, ie the
resulting shortened range should return the correct sequence. If it doesn't
recalc auto, check and ensure that calc mode is set to auto (via
ToolsOptionsCalculation tab). From your comments, believe your calc mode
might have been inadvertently set to manual.

If you insert new rows, you need to copy down the formula from the cell above.

I thought maybe the other posts would do it, but I couldn't get any of the
other presented solutions to work.

As the original poster, you should always try to post back to all responders
individually who offered you their thoughts. I do that if I'm the orig.
poster.

Anyway, except for Bernie's suggestions (where I think "1.10", "1.100", ..
would appear as "1.1" instead), I could get Rick's and Gord's suggestions to
work. But since Rick's/Gord's suggestions are not formulas, the numbering for
the range below would not adjust for any in-between row deletions, you would
need to re-fill the series from above.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---