Modify Max function for generating serial numbers of alphanumeric.

[VDS]

Dear All,

I have been using the function =MAX($A$2:A2)+1 /=MAXA($A2:A2)+1 to generate the serial numbers starting from 1,2,3, etc. This is useful not to disturb remaining rows, if a particular row is deleted say (from a range of from 1 to 15 and row no 8 is deleted).
Here, I want to add the (.) Just like bulleting. Like 1.2.3, etc. I tried to add &"." with the max function with a group of rows. In all the rows IT displays only 1.


What I need is to repeat the serrial numbers with (.)


How it can be done, Help is requested.


VDS

 

[Hui]

As Text =MAXA($A2:A2)+1&"."
or
As a Number, Format the cells using a custom number format 0.

 

[VDS]

@ Huli sir,

Thanks a lot

VDS

 

[Khalid NGO]

Or you can use in A2:
=ROW()-1

Custom format as
00.

 

[VDS]

Dear All

This query is now solved. Thanks a lot.

VDS