numbering rows

  • Thread starter Thread starter JohnB
  • Start date Start date
J

JohnB

Excel 2007
I know how to get a basic number list in a row, with: =ROW(A1)

But I would like a numbered row with a period and parenthesis, like:
1.)
2.)
3.)

How would I do that?

Thanks
 
Hi John,
Use the following formula:-
=ROW(A1)&".)"
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
Use this Custom Format...

0.);;

for the entire Column A (or for a known maximum range within Column A) and
then just put your row numbers in as normal numbers (1, 2, 3, etc.). If you
would like to "push" the value away from the right side of the cell just a
little bit, use this Custom Format instead...

0.) ;;""
 
That's pretty cool. For some reason though it doesn't increment when I drag
the corner. You have to enter each manually as you say. But good to know
none the less. Thanks.
 
Put 1 in A1, put 2 in A2, then select A1:A2 and click-drag the small black
square at the bottom right corner of the selection down as far as you want
to populate your numbers.
 
Back
Top