Excel Quirks - Not a Question

[Gettingbetter]

Just thought I would post this for a laugh,

I found a little excel quirk and thought I would share it,

if you type in a cell =""& and the press alt and enter then type the @ sign and press alt and enter then press the @ sign (repeat the @ and alt enter a couple of times) and your " sign swaps with your @ sign.

Repeat the above to swap them back.

Very Unusual!

Does anyone else know any funny things like this

 

[Richard Schollar]

Sounds like you're changing your keyboard setting from British to Yank (I hope Truby reads this and gets offended, the vegetable-intolerant so-and-so). Didn't realise you could do it as you specified though.

Richard

 

[Greg Truby]

1. @ albino carrot -- who tinkled in yer oatmeal this morning. Somebody's a bit grumpy on a Monday - lose a couple of quid bettin' on the ponies this weekend or sumpin'? sheesh
2. @ Gettingbetter -- If you are indeed toggling keyboard settings, you might have a look in the control panel under Regional and Language Settings on the Languages tab there's a Details... button. That opens up a Text Services and Input Languages Dialog on the Setting tab you can add language drivers. I flip between US & Spanish drivers when I need to type e-mails (or MrExcel posts) in Spanish. You can specify hot-key combos using the Key settings... button to allow you to quickly flip board drivers (provided you can remember what the dickens they are).

 

[Richard Schollar]

@ albino carrot -- who tinkled in yer oatmeal this morning. Huh Somebody's a bit grumpy on a Monday - lose a couple of quid bettin' on the ponies this weekend or sumpin'? sheesh

The vegetable patch enforcers, aka the Jerusalem Artichokes and the Brussel Sprouts, are on to you Trudy. I almost feel sorry for you

 

[Greg Truby]

I was going to make a smart comment along the lines of "bring it on, I likes salad"!

However, I'm actually a little nervous about battling veggies with a fork and knife at the moment since we've had this e.coli scare going on. I eat salad every day and I frequently buy salads under a couple of the brands that have been recalled in the last week so I'm just a little spooked by dangerous veggies this week

 

[Joe4]

So much for the thought that it is healthier to be a vegeterian!

 

[Cbrine]

Well us carnivore's get mad cow, as well as the occasional E.Coli scare. I kinda feel sorry for Popeye though.

 

[Oaktree]

Well us carnivore's get mad cow, as well as the occasional E.Coli scare. I kinda feel sorry for Popeye though.

Popeye was all about the canned spinach though (as opposed to bagged). So, he's still safe.

 

[Greg Truby]

Well us carnivores get mad cow...
-cbrine

Crikeys, Cal, I'd managed to forget about that! I hope I didn't give them impression that I only eat salads. I try to eat about 200g-250g of protein on days I go to the gym and 100g-150g on days that I don't lift. So that means meat figures prominently into my diet! [Life w/o a little BBQ now and then wouldn't be worth livin'.]

smugly to self as heads out the door for 'chest and back' night at the gym..."well, another lounge thread successfully detoured"...

 

[Richard Schollar]

I eat salad every day

Of all the dastardly things you could have said to me...