Elucidating loquacious ingenuitive titillating entrepreneurial - Bubbs’ Babes :):):)

Bargain_Bunny

Enterprise_1701C wrote: »

Right, strange question and probably totally the wrong place, but it is something I need to do shortly.

I need to create a list of sequential serial numbers. the format it

XXXX/001/XX/XX

I have access to word 2003, Excel 2003 and open orifice.

Has anybody got any ideas please, before I go utterly mad. I know you can drag the numbers down in Excel but that requires that the number be on the end of the sequence, and I am trying to do it as simply as possible as I have to create hundreds of these!

Thank you to anyone that can answer.

You could use custom cell formats in Excel, then pull the number apart in cells to the right to get the "/" added.
Go to format cell, custom, create a custom format that is simply 8 0's - this will allow you to have "leading zeros" in the cell. Then put 00000000 in first cell, 00000001 in second, drag down all the way to copy downwards until you get to 99999999.
Then you just need to pop the "001" and "/"'s into the final output.

To do this, pull the first 4 digits out in one cell to the right (using for example the "mid" command (=mid(a1,1,4)), the next 2 into the next cell, the last 2 into another, and use concatenate command to join them (=concatenate(A2,"/001/",A3,"/",A4,").

Sunshinemummy

Savvybuyer wrote: »

I bet they did!:):)

One though - it may take me, or some of us, some time before we do our very first post, but once we do it often seems we are 'hooked' and then keep posting again and again! I remember you, Sunshinemummy:rotfl::rotfl::rotfl::rotfl:(and then:rotfl::rotfl: at my :rotfl::rotfl::rotfl::rotfl:), posted the first post as just popping on - but here ever since:T. And welcome Claire Alex - I thought I may have been a little rude then, me slipping in to say mine may be more recent(:p) - but I know fortunately not taken that way as you thanked me!:T Welcome to the thread!:):D:)

I did lurk forever, and now am a like a bad penny, you just cannot get rid of me.... but hopefully I am spreading the love!

:T:T:T

Sarahdol75

perkypam123 wrote: »

That looks lovely.

Call_of_Trouty wrote: »

If going by car look out for potholes, they can do serious damage.

:rotfl::rotfl::rotfl::rotfl:

Sunshinemummy

emerald21 wrote: »

Lol I'm not that much of a gobby cow :rotfl:

I always picture you as a lady
.

.
.
.
.
.
.
.
.
.
.
.
Dressed in leather and whipped Tom!

:eek::eek::eek::eek:

aau1

Enterprise_1701C wrote: »

Right, strange question and probably totally the wrong place, but it is something I need to do shortly.

I need to create a list of sequential serial numbers. the format it

XXXX/001/XX/XX

I have access to word 2003, Excel 2003 and open orifice.

Has anybody got any ideas please, before I go utterly mad. I know you can drag the numbers down in Excel but that requires that the number be on the end of the sequence, and I am trying to do it as simply as possible as I have to create hundreds of these!

Thank you to anyone that can answer.

is the second block of characters the only thing that changes

If so, you could do 4 columns in an excel spreadsheet (1, 3 and 4 identical in every row) but do the number drag trick you are talking about for column 2

Then use the concatenate command to join up the four columns into a new column 5

Bargain_Bunny

aau1 wrote: »

is the second block of characters the only thing that changes

If so, you could do 4 columns in an excel spreadsheet (1, 3 and 4 identical in every row) but do the number drag trick you are talking about for column 2

Then use the concatenate command to join up the four columns into a new column 5

Good point - I assumed the 001 bit was the constant, and the x's were the bit that varied Much easier if it's your way around

jax.26

Yoghurt_Queen wrote: »

Funilly enough, both my son and my husband LOVE cobra. They never used to, but they've grown to love it. Me? I hate it at the moment. Not that i've even had a sip and I wont be. I can't wait till its all drunk and out of my sight tbh! Hey ho.

So sorry to hear this YQ.

My son and Hubs also like this beer, saying it is a very smooth beer! Which means I also have taken advantage as much as possible...so, I'm as guilty as you-only you got caught.

I would think most peeps took as much as was available due to some ones taste (hubs and son) and xmas as well as new year celebrations fast approaching.

So, don't feel ashamed amongst us:beer::beer:
xx

Claire_Alex

Anybody need Mr Muscle Kitchen and Bathroom Drain Gel?

Currently half price (normally £3.95) and 100% extra free (1000ml for the price of 500ml) at Morriebobs for £1.97

Claire_Alex

A v M womble for Savvy from last night:

0.11 x ASDA Carrots per kg £0.09 £0.09
0.29 x ASDA White Baking Potatoes per kg £0.42 £0.46
1 x ASDA Jumbo Garlic £0.47 N/A
1 x Walkers Wotsits Really Cheesy Corn Puffs (6x19g) £1.34 £1.68
1 x Walkers Monster Munch Flamin' Hot (6x22g) £1.33 N/A
1 x Walkers Monster Munch Pickled Onion (6x25g) £1.33 £1.68
1 x Stone's Original Green Ginger Wine (700ml) £6.00 £6.10
1 x Baileys Original Irish Cream Liqueur (1L) £10.00 £18.00
1 x Mug Shot Pasta Creamy Cheese (68g) £0.40 £0.75
1 x Mug Shot Pasta Roast Chicken Flavour (55g) £0.40 N/A
1 x Mug Shot Noodles Thai Style (55g) £0.40 N/A
1 x Mug Shot Pasta Mediterranean Style (60g) £0.40 N/A
1 x Mug Shot Noodles Peri Peri Flavour (56g) £0.40 £0.75
1 x ASDA Whole Cucumber £0.50 £0.65
1 x ASDA Organic Butter Beans in Water (400g) £0.70 N/A
1 x ASDA Fresh Tastes Ranch Salad (300g) £1.00 N/A
1 x ASDA Juicing Oranges (1.6Kg) £2.25 N/A
1 x ASDA Extra Special Pains aux Raisins (2) £1.00 N/A
1 x Coca Cola (8x330ml) £2.50 £4.20
1 x Nestle Pure Life Spring Water (12x500ml) £2.30 £2.29

Look at Baileys :eek:

Claire_Alex

Another A v M womble

1 x ASDA Semi Skimmed Milk 2 Pints (1.14L) £0.89 £0.89
2 x ASDA Chosen by You Chips & Curry Sauce (400g) £2.00 N/A
1 x Marmite Yeast Extract (125g) £1.70 £1.70
1 x Diet Coke (500ml) £1.15 £1.19
1 x Maltesers Advent Calendar (112g) £2.00 N/A
1 x Maltesers Funsize (9 per pack - 214g) £1.00 £2.00
1 x McVitie's Jaffa Cakes Mini Pods (6 per pack - 238g... £1.00 £1.69
1 x McVitie's Milk Chocolate Hobnobs (262g) £1.00 £1.50
1 x Young's Flipper Dippers 100% Fish Fillet (10 per p... £1.00 £1.00
1 x Branston Baked Beans (3x410g) £1.00 N/A
2 x Branston Baked Beans with Sausages (405g) £1.74 £1.78
1 x Walkers Quavers Cheese Flavour (14x16g) £2.00 £3.59
1 x Weetabix Cereal (12x18g) £1.48 £1.49
2 x Uncle Ben's Express Golden Vegetable Rice (250g) £2.00 £3.38
1 x Thorntons Snowman Advent Calendar (83g) £2.00 N/A
1 x Cadbury Crunchie (4x40g) £1.00 £1.00
1 x Ryvita Pepper Crackerbread (125g) £1.19 N/A
1 x ASDA Kids Bath Cheeky Cherry (500ml) £1.00 N/A
1 x ASDA Chosen by You Marshmallow Snowballs (14) £1.50 N/A
1 x ASDA Mini Jam Teacakes (16) £1.50 N/A
1 x ASDA Sausage & Bean Bakes (2 per pack - 280g) £1.00 N/A
1 x ASDA Chosen by Kids Cheese & Tomato Pizzas (4 per ... £2.00 N/A
1 x Diet Coke (8x330ml) £2.50 £4.20
1 x Nestle Smarties Tube - Pink (170g) £1.00 £1.00
1 x Nestle Blue Riband (8x19.3g) £1.00 £1.55
1 x Ferrero Rocher (200g) £3.00 £3.49

Don't get your Diet Coke from Morries