| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
generate numbers
We have designed tickets and each will have a number:
VIP-0001 VIP-0002 VIP-0003 etc. Is there something I can set up so the tickets will automatically generate a new number so I won't have to go in and manually type them. We have up to VIP-0500. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
generate numbers
Enter VIP-001 in A1, select it and position the mouse at the lower right-hand
corner. When the pointer become a pure + (no arrows on the plus), right click, pull-down, and select: Fill Series -- Gary''s Student - gsnu200745 "Pammy" wrote: We have designed tickets and each will have a number: VIP-0001 VIP-0002 VIP-0003 etc. Is there something I can set up so the tickets will automatically generate a new number so I won't have to go in and manually type them. We have up to VIP-0500. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
generate numbers
If you type in VIP-0001 in cell a1 and drag it down the number should
increment. If that is not working for you then you could put 1, 2, 3, ... in Cells A1, A2, A3, ... and format the cells with a custom format like this... Format Cells|Number|Custom - VIP-0000 -- HTH... Jim Thomlinson "Pammy" wrote: We have designed tickets and each will have a number: VIP-0001 VIP-0002 VIP-0003 etc. Is there something I can set up so the tickets will automatically generate a new number so I won't have to go in and manually type them. We have up to VIP-0500. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
generate numbers
Enter VIP-001 in the first cell then hover the cursor over the bottom
right-hand corner of the cell where there is a small black square calledthe "fill handle" When over the fill handle the cursor will change to black cross-hairs, (don't be confused by tyhe four-headed arrow cursor the appears when you are on the cell border). Left-click and hold pressed and drag down tghe column and the numbers will index automatically -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Pammy" wrote in message ... We have designed tickets and each will have a number: VIP-0001 VIP-0002 VIP-0003 etc. Is there something I can set up so the tickets will automatically generate a new number so I won't have to go in and manually type them. We have up to VIP-0500. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random numbers | Excel Discussion (Misc queries) | |||
| How to generate #'s that excludes certain numbers? | Excel Worksheet Functions | |||
| Generate new account numbers? | New Users to Excel | |||
| generate consecutive numbers | New Users to Excel | |||
| generate random numbers | Excel Worksheet Functions | |||
Hybrid Mode
