View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
icius icius is offline
external usenet poster
 
Posts: 1
Default Autofill outline numbering

Hello all,

I would like the following kind of numbering:

4.1
4.2
4.3
4.4
4.5
4.6.
4.7
4.8
4.9
4.10
4.11
4.12
etc.

I would like to be able to put in 4.1 and then drag/autofill down to as
far as I need to go. Naturally Excel is treating this like a decimal
and after 4.9 it goes to 5.0 which is not what I want. What I am
trying to convey is that these rows are in "Section 4". It would also
be great if when I inserted a new row in the middle that all subsequent
rows were renumbered correctly. Can anyone think of a formula or way
to do this?