macro - enumerating ?

[de_xt_er]

Hi all,

this problem to all of you may look trival, but I need some help with this.

I got the sheet in excel looking like this :

A B
Which is the deepest loch in Scotland ?
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

What was the first of Earth's supercontinents ?
a) Pangaea
b) Gondwanaland
c) Rodinia
...


and so on..

I need to put the numbers in the row A so they are in front of each
question in row B. They should start with 1. and finish with the last question in the table.
The number of answers differ, there are 4 or 5 answers for the each
question.

Basically - something like this:

A B
1. Which is the deepest loch in Scotland ?
a) Loch Lomand
b) Loch Ness
c) Loch Morar
d) Loch Smith

2. What was the first of Earth's supercontinents ?
a) Pangaea
b) Gondwanaland
c) Rodinia
...

P.S. All the questions are in bold, maybe this could help ?

Is this doable ?

Thanks in advance !

[JBeaucaire]

Select column A and press CTRL-1 to open the Format Cells box.
Select Number > Custom > Type: #)

(you'll have to enter that red bit yourself.)

Now, the following formula can be used to autonumber your questions, as long as the questions and answers are all in column B, perhaps starting at row 3:

=IF(OR(ISNUMBER(FIND(")",B3)),B3=0),"",MAX($A$1:$A2)+1)