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?

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

Thanks again. If you have further input about the auto update let me know.

"Max" wrote:

One way ..

Place this in the top cell (eg: in C5), then copy down:
="1."&ROWS($1:1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MAnderson" wrote:
Is it possible to specify a formula that creates a custom numbering format.
For example, I want to set up a column that can do this:

1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
1.10
1.11, etc.

I tried to do decimal addition, but that doesn't allow 1.10, 1.11, 1.12, etc.

Is there a way to do this using the standard features of Excel, or does
someone know the formula to program this?

Thanks.