numbering rows

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
 
R

Rick Rothstein

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.) ;;""
 
J

JohnB

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.
 
R

Rick Rothstein

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.
 
Top