Right click sheet tabview codeinsert thischange f1 to your cell address.
Now when you right click on the cell the number will be increased by 2

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Intersect(Target, Range("f1")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target = Target + 2
Application.EnableEvents = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DB." wrote in message
...
Thanks for your quick reply, Don.
But holding down the f2 key and hitting "2" appends a 2 to the end of
the number (so that 15016283 becomes 150162832) whereas I want to increase
the number itself by 2 - i.e. for it to become 15016285.
Is there a simple way to do this, please? (And, similarly, a simple
way to subtract that 2 from my original number?).
Thanks again,
--
DB.



"Don Guillett" wrote in message
...
Try touching the f2 key

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DB." wrote in message
...
I have a very large number (8 digits, perhaps) in a cell and wish to
increase marginally that number (add 2, say) without re-typing (almost)
the entire string of digits. Is there an easy way (maybe holding down a
simple key-combination then hitting "2") that will achieve my aim?

TIA of any reply.
--
DB.