Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition?
Im am currently creating a database of my audio cds..
Rather than going alphabetically i am using stickers - each page of stickers consist of 48 stickers a4 size - (16 x 3 rows) and i have started to print some up ie Cd 00001 to Cd 00048 on one sheet etc and so on..then in excel the cd will tie up with the sticker etc Now Instead of manually changing each number for the next sheet ie Cd 00001 becomes Cd 000049 and so on, i was wondering is there a easy way of just adding a addition 48 to each number so 01 becomes 49, 02 becomes 50 and so on.. Thanks -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service -------http://www.NewsDem |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition?
Frodo Wrote: Im am currently creating a database of my audio cds.. Rather than going alphabetically i am using stickers - each page of stickers consist of 48 stickers a4 size - (16 x 3 rows) and i have started to print some up ie Cd 00001 to Cd 00048 on one sheet etc and so on..then in excel the cd will tie up with the sticker etc Now Instead of manually changing each number for the next sheet ie Cd 00001 becomes Cd 000049 and so on, i was wondering is there a easy way of just adding a addition 48 to each number so 01 becomes 49, 02 becomes 50 and so on.. Thanks -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service -------http://www.NewsDem you will ave to give way more information If you set up you sheet just with numbers you could paste special and add 48 to each number. Or create a seperate sheet or area, put just the numbers in as numbers accepting the leading 00 will me missing then in the first cell of your labels put ="cd"&TEXT(J40,"00000") where j40 is the cell contain 1 or 49 etc Regards Dav Alternatively it is easier in word, make a list of all the numbers you want and create a labels mail merge just putting cd and the number on the labels, if the number is formated 00000 -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=563944 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition?
Slight variation: If you make the top-left cell in the block the source for the rest, and input it manually as a number, eg 49, then set up a formula so that every other cell adds 1 to the previous cell, eg B1 = A1+1 Then format the cells as "Cd "000000 (custom format), and each sheet can then be created by inputting one number. Regards Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=563944 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition?
Select A1:R3 (16 columns by 3 rows)
With A1 the activecell, type this formula: ="Cd "&TEXT(48*$A$10+(ROW()-1)*16+COLUMN(),"00000") and hit ctrl-enter to fill all the cells in the selection. Now put 0 in A10, then put 1 in A10, then 2, .... Frodo wrote: Im am currently creating a database of my audio cds.. Rather than going alphabetically i am using stickers - each page of stickers consist of 48 stickers a4 size - (16 x 3 rows) and i have started to print some up ie Cd 00001 to Cd 00048 on one sheet etc and so on..then in excel the cd will tie up with the sticker etc Now Instead of manually changing each number for the next sheet ie Cd 00001 becomes Cd 000049 and so on, i was wondering is there a easy way of just adding a addition 48 to each number so 01 becomes 49, 02 becomes 50 and so on.. Thanks -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service -------http://www.NewsDem -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel addition of column | New Users to Excel | |||
addition | New Users to Excel | |||
count number of values between plus signs in addition calc | Excel Discussion (Misc queries) | |||
Addition base on condition | Excel Worksheet Functions | |||
help with simple addition formula | Excel Worksheet Functions |