Is it possible by some formatting trick to have A1 contain i (Roman numeral 1),
A2 contain =A1+1,
A3=A2+1
and so on, so that successive vertical cells appear as
i
ii
iii
iv
v
...
?
Like you can do with Word numbering?
Incrementing Roman numerals
-
- PlatinumLounger
- Posts: 5411
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Incrementing Roman numerals
John Gray
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
-
- Administrator
- Posts: 78535
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Incrementing Roman numerals
No, but you can enter 1 in A1, =A1+1 in A2 etc., and then have the corresponding Roman numerals displayed in column B:
In B1, enter the formula =ROMAN(A1) and fill down; this will result in I, II, III, IV, ...
If you prefer lower case, use =LOWER(ROMAN(A1))
If desired, you could now hide column A.
In B1, enter the formula =ROMAN(A1) and fill down; this will result in I, II, III, IV, ...
If you prefer lower case, use =LOWER(ROMAN(A1))
If desired, you could now hide column A.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 5411
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Re: Incrementing Roman numerals
Brilliant, as ever! Thanks!
John Gray
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...