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

BrummieBungo

Need to top up my wombles and get dinner. Feel a bit of a muppet getting salad in this weather so lets see what the whoospsies bring

BrummieBungo

Oh and beans are still working

Dizzy_Ditzy

LilacLillie wrote: »

Are the crisps walkers 20 x 25gm classic & meaty variety, 1 of each or 2 of the same please?
Sorry to hear QOC bad news at Asda.
I rang Tesco yesterday to complain I was refused DTD yet again (even though I carry a print out email of coupon and DTD with me), only to be told 'You are known to Tesco'.
'Yes (I replied) its because no stores offer the DTD you advertise, and if it happens again I'll call again'.
I only ever call if they make an obvious mistake and won't honour it.
The other day they added £9 on bill instead of deleting it, then said it wasn't an overcharge it was a mistake!
LL

It wasn't me, it was yogurt queen

aau1

Bargain_Bunny wrote: »

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,").

Or just type 1,2,3,4,5 drag down to however many you need and set a custom formatting to show them as 001, 002, 003

Custom format command is #,000

and then concatenate (but I would do it differently to above :rotfl:)

mrsmac10

bubbs wrote: »

Lets not start arguments pleaaaasssseeeeee;):p[/QUOTE

No, lets not thanks. Where's my smiley face?

Bikertov

Savvybuyer wrote: »

I think I'd better get my big red cross out (or possibly the one I [Strike]steal[/Strike] borrow from Aau1).

Not absolutely correct that any store could ban anyone for "any" reason. If the reason was your sex or race they 'couldn't' (of course, they "could" but it would be illegal so in that sense "couldn't"), or if the reason they wanted someone to leave was connected to their disability (or, presumably, presumed disability);)?:D, also that perhaps wouldn't, in a word used occasionally by store staff members themselves, be "allowed".

On that basis Savvy, could you not claim that your Aspergers is a disability requiring you to write down prices in advance of a future shopping trip. Therefore you are being discriminated against?

Hope that has not come across in a disrespectful way....

Dizzy_Ditzy

Am just about to settle down to watch the Wales game on TV and more importantly, the England game on my lappie :j

With big, huge, massive thanks to Neosi and tweets :beer: :beer:

I'm not watching the Wales game yet.

It's England playing crappy league on t'telly

owt_for_nowt_2

Got something I need with a APG :j
Why £5.63?
«!Back to comparison results
13 items (10 different) on your bill qualify for comparison Morrisons
+£4.79
!
1 x ASDA Semi Skimmed Milk 6 Pints (3.41L) £1.48 £1.99
1 x ASDA Smartprice Chicken Flavour Instant Noodles (6... £0.20 £0.20
1 x ASDA Smartprice Instant Noodles Curry (65g) £0.20 £0.20
1 x Haribo Maoam Giant Strawberry Stripes £0.10 N/A
1 x Haribo Maoam Giant Sour Stripes (15g) £0.10 N/A
2 x Dolmio Bolognese Sauce - Extra Mushroom (500g) £3.00 £1.80
2 x Napolina Penne Pasta (500g) £2.76 £1.38
2 x Napolina Rigatoni (500g) £2.76 £1.38
1 x Bisto Stock Melts Vegetable (120g) £1.87 £0.48
1 x Hovis Original Sliced Wheatgerm Bread (400g) £0.70 £0.75
1 x Swizzels Matlow Strawberry Refresher Bar £0.10 N/A
1 x Haribo Starmix £0.10 £0.10
1 x Haribo Tangfastics £0.10 £0.10
1 x ASDA Chosen by You Giant White Mice Bar (15g) £0.10 N/A
1 x ASDA Chosen by You Giant Rainbow Buttons Bar (15g) £0.10 N/A
!

Claire_Alex

A v M

1 x ASDA British Whole Milk 4 Pints (2.27L) £1.00 £1.39
1 x ASDA Butcher's Selection British Pork Sausages (8 ... £1.50 N/A
1 x ASDA Chosen by You Fresh Cream Raspberry Turnovers... £1.60 N/A
2 x ASDA Baby New Potatoes with Herbs & Butter (360g) £2.00 N/A
1 x Ribena Blackcurrant Drink (600ml) £1.38 £1.99
1 x Warburtons Medium Sliced White Bread (800g) £1.00 £1.45
1 x ASDA Butcher's Selection Smoked Back Bacon Rashers... £2.54 £2.55
1 x ASDA Chosen by You Spatchcock Chicken Piri Piri (9... £4.50 N/A
1 x ASDA Extra Special Beer Battered Haddock with Chun... £3.25 N/A

aau1

Bargain_Bunny wrote: »

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

Whichever it is, I think that between us we'll be able to help :beer: