increment a number in brackets

F

Friedrich Vosberg

Morning

How can I increment numbers in brackets or with dot and bracket in each
cell of a column?

1.) | (1103)
2.) | (2206)
3.) | (4412)
... | (....)

TIA and kind regards. Friedrich
 
J

jpdphd

Does the bracket imply that this is a negative number? (1103)=-1103

To increment the number in any cell by a constant, type that constant
(e.g. 1) into a cell,
select this cell
Edit > Copy
Select the cells to be incremented
Edit > Paste Special - choose "Values" and operation "add"

jpdphd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top