Latest Lists

In Excel, how do I create a numbered list with periods?

I need to create a numbered list on the far left column, but I want to add periods after each number like this: 1. 2. 3. OR 1) 2) 3) How do I do that? I know how to do it without the symbols, but can anyone tell me how to do it with the period or parenthesis? Thanks!

Public Comments

1. put the numbers in the cells, then highlight them. Right click and choose Format Cells. In the dialog box, choose the Number tab. In the category list choose custom. You will see a textbox right under the word Type: Put #. or #) in that box You will see how it looks in the sample box. Click Ok and you are done.
2. Put this in cell a1 and fill down =row() & "." Bruce