Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |