Ask Your Question
0

how to display an automatic number in a series as in an invoice number? [closed]

asked 2012-10-13 12:37:49 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

how to display an automatic number in a series as in an invoice number?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 15:47:20.775267

2 Answers

Sort by » oldest newest most voted
0

answered 2012-10-13 18:01:02 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

An easier way is to type in the cell of your first invoice number the number you want to start with. Thereafter keep that cell selected and put the cursor on the small square at the bottom right corner of the cell. Press the left mouse button and pull down. The number increases automatically by one in each cell. (if needed you can do the same pulling to the right side.) This works only for numbers not for alphabetical characters.

edit flag offensive delete link more

Comments

That is the concept I was going for, too - it may be a better solution for when you want to delete a line.

mjjzf gravatar imagemjjzf ( 2012-10-16 13:32:33 +0200 )edit
0

answered 2012-10-13 16:36:03 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

The simplest way is of course to number the first one (A1) 1, the one below =A1+1 and just copy the whole thing downwards - if you have the entries in one line. Of course, this does not account for you having to erase some. But I seem to recall that there is an auto-numbering feature somewhere?

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-10-13 12:37:49 +0200

Seen: 164 times

Last updated: Oct 13 '12