Search results

Get him a bar of chocolate to cheer him up ;) http://tinyurl.com/34vazfn Or maybe instead start a collection to help him with the repair bill

Thanks for all the replies and ideas, some things to check and think about then. Bolting through sounds like a good idea, I'll look into it.

Hi. I have two roughly 8"x8" gate posts that I've re-used as post supports for a hammock. They were originally located outside but then pulled up and stored inside an unheated workshop for about a month. To make them more attractive I wanted to paint them with black external wood paint. To give...

Not sure if soda crystals are essentially the same as baking soda, but that is what I have read is a good solution. The other thing I did was remove the rubber door liner which had a build up of black mouldy type stuff, and gave it a good clean. This was more to do with something was staining my...

Would be a bit of a trek for you.. I saw your last question over on the gardening forum. The ones we planted (4 different types) all said to bury them to 30 cm. I can't remember whether that was to the top of the mound or the bottom, but I suspect a lot deeper than you currently have them...

I had taken the photos as we blog a lot of what we do around the house and garden for the benefit of my other half's family who all live abroad and the title of the post was The Aliens are Coming, for just that reason. It was also a play on the name of a Spanish song (my other half is...

We planted some out last November The bed has been pretty much waterlogged for the last few months and we had assumed it was dead, but then at the weekend, on the off chance we had a look and saw this so very satisfying to see it actually growing. It's one of eight shoots and we hope to...

Sorry to hijack the thread a little, but since there are obviously people here that know I thought I'd take advantage of it. Can someone pls identify this bird, I thought it might be a kestrel, but not sure. We have several birds of prey in the area that can be seen flying, but this one is a...

Just getting into beekeeping myself, one piece of advice I got on the beginners beekeeping course was to ensure that if you join a local beekeping assocation make sure they are affiliated to the BBKA, that way you get insurance against loss of your colony, however if your mother is getting her...

I tried a cooling mod on mine, found it on one of the xbox hack forums. Involved dremeling out parts around the fan to fit a larger quieter fan, and then replacing the cheap paste on the chips with something alot better. I also went further and dremeled alot of the inside, relocated the HDD etc...

Hi Brian, it sounds like a DAC (Digital to Analogue Converter) is what you need. It's not something that I have ever looked at in detail to make any recommendations, but seem to recall that, budget dependent, sometimes offer multiple inputs, though you may find they are of differing types, to...

The 75mm hose that I bought, this one http://www.axminster.co.uk/product-Axmi ... -22321.htm fitted over a 75mm gasket I also got from Axminster, and the 75mm extraction port on my thicknesser, so my guess would be it's the internal diameter, but am more than happy to measure all 3 if you're...

Hi Martin, likewise I'm not up to date with current tools/software. There is one particular free app that I use but it is relatively old and I have had issues with several DVDs. I'm new here and I'm not familiar with forum policy on discussions of this type of thing so I don't want to say too...

Steve, I think this might help - http://www.mrexcel.com/articles/pivot-t ... -month.php I just tried it and it works, it allows the date fields in a pivot table to be grouped in various ways, including summing day totals into their equivalent month. I use Office 2007 and I think this may be...

Gotcha, I had thought for some reason that each row was a date and total sales for that date. So you mean a 'group by' in SQL terms?

Do you mean a running total? You could try this formula =SUM($A$1:$A1) This would go in the first cell of your running total, and A1 is the cell containing your first sales entry. Drag the formula (black cross after hovering over black square in bottom right corner) down to the end of your...

Hi Roger, good spot. I am using the comma to pretty much drive all string extraction, I'd missed a +1 though. Hopefully this should do it =MID(A1,SEARCH(" ",A1)+1,SEARCH(",",A1)-SEARCH(" ",A1)-1)&"/"&LEFT(A1,SEARCH(" ",A1)-1)&"/"&MID(A1,SEARCH(",",A1)+2,4)

Mike, I think Brendan meant Mike Saville's idea of vac on top on wheels, as per Niki's that he has linked to.

That's rubbish.... this one should work =MID(A1,SEARCH(" ",A1),SEARCH(",",A1)-SEARCH(" ",A1)-1)&"/"&LEFT(A1,SEARCH(" ",A1)-1)&"/"&MID(A1,SEARCH(",",A1)+2,4) and allow for any length month and day, but assumes a 4 char year

Assuming dates are always in either of these two forms MMM D, YYYY or MMM DD, YYYY then this should work =MID(A1,5,SEARCH(",",A1)-5)&"/"&LEFT(A1,3)&"/"&MID(A1,SEARCH(",",A1) +2,4) if the month varies in length then this should work =MID(A1,5,SEARCH(",",A1)-5)&"/"&LEFT(A1,SEARCH(" ", A1)...