Author |
Message |
cloaked_wolf
What's a life?
Joined: Thu Apr 23, 2009 8:46 pm Posts: 10022
|
Interesting. I was gonna try some combo of a coconut and a lime scented product so I'd smell like a million dollars! I think I'll go for a shaving cream. Been looking at Taylors of Bond Street and Trufitt&Hill products.
_________________ He fights for the users.
|
Thu Jan 26, 2012 12:18 am |
|
 |
saspro
Site Admin
Joined: Thu Apr 23, 2009 5:53 pm Posts: 8603 Location: location, location
|
Taylors creme isn't bad. It's a tad dry compared to GFT. The Bodyshop do quite a nice shaving cream.
|
Thu Jan 26, 2012 9:35 am |
|
 |
HeatherKay
Moderator
Joined: Thu Apr 23, 2009 6:13 pm Posts: 7262 Location: Here, but not all there.
|
I have some gaps in my NI contributions. I've been trying to get a definitive figure so I can get the gaps filled. Every statement I get has different numbers on it. The current one even includes the following pleasantry: Nice. It's not that I don't want to pay. I just don't want to have to keep paying random numbers without having an answer to the letter I wrote to them back in December. 
_________________My Flickr | Snaptophobic BloggageHeather Kay: modelling details that matter. "Let my windows be open to receive new ideas but let me also be strong enough not to be blown away by them." - Mahatma Gandhi.
|
Thu Jan 26, 2012 4:39 pm |
|
 |
rustybucket
I haven't seen my friends in so long
Joined: Thu Jun 18, 2009 5:10 pm Posts: 5836
|
I've got the same problem. F***ing amateurs!
_________________Jim
|
Thu Jan 26, 2012 4:42 pm |
|
 |
leeds_manc
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 8:19 pm Posts: 5071 Location: Manchester
|
I want to meet the designers of Microsoft Word 2010 and follow them around all day slightly correcting everything they do, if they select a Crunchie from the vending machine for instance, I'll slightly correct this to a Twirl. If they put anything down on their desk, I'll move it, align it in some arbitrary way. I'll listen to them on the phone and suggest words they should have used.
Alternatively I want to smash their faces in with a cricket bat, all of them, even the women.
|
Thu Jan 26, 2012 8:40 pm |
|
 |
belchingmatt
I haven't seen my friends in so long
Joined: Fri May 15, 2009 3:16 am Posts: 6146 Location: Middle Earth
|
I hear that Chris.
_________________ Dive like a fish, drink like a fish!
><(((º>`•.¸¸.•´¯`•.¸><(((º> •.¸¸.•´¯`•.¸><(((º>`•.¸¸.•´¯`•.¸><(((º>
If one is diving so close to the limits that +/- 1% will make a difference then the error has already been made.
|
Thu Jan 26, 2012 8:47 pm |
|
 |
JJW009
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 6:58 pm Posts: 8767 Location: behind the sofa
|
I used Excel today. It excels at being a smartarse that doesn't know what you want...
Not Deleting the Critical leading zeros on phone numbers requires importing a csv as text and manually setting the header to text. Then, when you save it it either leaves off the quotes or doubles them up! It's often quicker to use f*cking Notepad...
_________________jonbwfc's law: "In any forum thread someone will, no matter what the subject, mention Firefly." When you're feeling too silly for x404, youRwired.net
|
Thu Jan 26, 2012 9:11 pm |
|
 |
Alexgadgetman
Occasionally has a life
Joined: Fri Apr 24, 2009 4:56 pm Posts: 306
|
Really randomly... do you fancy explaining how you do this?! I use excel every day to record customer information and when I was given the document all the zeros were gone from the front of the numbers and I decided against trying to rectify it. I would be interested to know how it can be done...
|
Thu Jan 26, 2012 10:02 pm |
|
 |
jonlumb
Spends far too much time on here
Joined: Thu Apr 23, 2009 6:44 pm Posts: 4141 Location: Exeter
|
If it's a one off procedure I'd just use concatenate into a column of cells formatted as text.
_________________ "The woman is a riddle inside a mystery wrapped in an enigma I've had sex with."
|
Thu Jan 26, 2012 10:40 pm |
|
 |
JJW009
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 6:58 pm Posts: 8767 Location: behind the sofa
|
Concatenating is fine if the number of leading zeros is always the same. This is not the case with phone numbers, where UK numbers in local format begin with a single zero and international with double zero. The process I use is to rename the file to wotever.txt and then open it. You get the import wizard thing. The critical step is to highlight all the columns and set them to type "text". If quotes are involved, you also need to deselect the "text identifier" option. Of course, Excel then spends the rest of the day underlining all the phone numbers with a wiggle and shouting at you "This is numbers not text it is it is I tell you! Let me sort them numerically! I want to do maths on them!" I really wish there was a "leave my data the hell alone and just show it like it is" button... Maybe there is, but I don't know anyone that found it yet 
_________________jonbwfc's law: "In any forum thread someone will, no matter what the subject, mention Firefly." When you're feeling too silly for x404, youRwired.net
|
Thu Jan 26, 2012 11:14 pm |
|
 |
HeatherKay
Moderator
Joined: Thu Apr 23, 2009 6:13 pm Posts: 7262 Location: Here, but not all there.
|
HMRC on-hold music is awful.
_________________My Flickr | Snaptophobic BloggageHeather Kay: modelling details that matter. "Let my windows be open to receive new ideas but let me also be strong enough not to be blown away by them." - Mahatma Gandhi.
|
Fri Jan 27, 2012 10:26 am |
|
 |
phantombudgie
Doesn't have much of a life
Joined: Wed Aug 19, 2009 1:45 pm Posts: 994
|
The one feature it truly needs! What they will do next is this: when you try and import something that may have phone numbers in, it will pop up with a clippy-type wizard that says "It looks like you're trying to import phone numbers. What would you like to do?" There are three options: the first imports them as a number so you loose the zeroes, the second always crashes the PC, and the third will randomly assign the column entries to either numbers or text...
|
Sat Jan 28, 2012 12:46 pm |
|
 |
veato
I haven't seen my friends in so long
Joined: Fri Apr 24, 2009 7:17 am Posts: 5550 Location: Nottingham
|
Stupid batteries. Why u no magically charged!
Now I can't take the photos I wanted to until later.
_________________Twitter Blogflickr
|
Sat Jan 28, 2012 1:14 pm |
|
 |
cloaked_wolf
What's a life?
Joined: Thu Apr 23, 2009 8:46 pm Posts: 10022
|
Did you not have back up batteries?
_________________ He fights for the users.
|
Sat Jan 28, 2012 2:08 pm |
|
 |
forquare1
I haven't seen my friends in so long
Joined: Thu Apr 23, 2009 6:36 pm Posts: 5159 Location: /dev/tty0
|
[LIFTED] dry cleaners closing at 15:00 on a Saturday and closed all say Sunday. Put one of Faye's jackets in on Wednesday and they said "It should be ready on Saturday afternoon". I left the house at 3, giving them the best chance to have had it ready, and they bloody closed when I got there. Now Faye doesn't have a jacket to wear for her interview on Monday so the whole weekend is buggered while we travel to Swansea tomorrow and see if they have it in stock. She works for the company that sells it so I don't know why she can't see if Swansea have it and then reserve it.
So many things to get done and now zero time to do them...
|
Sat Jan 28, 2012 5:21 pm |
|
|