|
As seen live on
closed-circuit TV, here's - NOISES
FROM THE BASEMENT
|
|
May 15, 2002 |
Vol. 3, Issue 4 |
|
|
| Contents
1) Timely Tips - "Excel
Custom Date Formats"
2) File Find! - "CleverKeys"
3) Sites-Seeing - "Outer
Space, Out of Mind, Outside the Law"
4) Email Funny - "Mind Reader"
5) They Said It - quotes to give one pause
6) Hodgepodge - that what fits no where else
Thanks again for clicking this
one open and spending a few minutes in The Basement! If you're new
here, I'd like to extend a special welcome! I hope you find Noises
From The Basement a comfortable Inbox friend in the
future! Myself, staying busy with
fighting my own "end-of-school-year" battles with students... little
do they suspect that I'm as eager for the break as they are!
Enjoy this week's offerings, and
feel free to
drop
me a comment on what you liked, disliked, or would like to
see in the future! - Dave
|
|
|
1) Timely Tips - "Excel Custom
Date Formats" Here's how
to create your own Custom Date
Formats in Excel:
- Select the cell(s) that
contain the dates you want to format.
- From the menu chose Format
> Cells > Number tab > Custom
category.
- Use the following table for
the date symbols you can use:
|
Symbol |
Description |
Example |
|
Symbol |
Description |
Example |
|
Symbol |
Description |
Example |
|
m |
month digit |
7 |
|
d |
day digit |
5 |
|
y |
last two
year digits |
02 |
|
mm |
month digit,
leading zero |
07 |
|
dd |
day digit,
leading zero |
05 |
|
yy |
same |
02 |
|
mmm |
month 3-letter
abbreviation |
Jul |
|
ddd |
day 3-letter
abbreviation |
Sat |
|
yyy |
full year |
2002 |
|
mmmm |
full name |
July |
|
dddd |
full name |
Saturday |
|
yyyy |
same |
2002 |
|
mmmmm |
1st letter month |
J |
|
So-- 2/2/2002 formatted as "dddd, mmmm dd,yyyy"
would yield: Saturday, February 02, 2002
|
Remember to use
spaces and commas where needed, as you write your date code
formats!
Return
to top
|
|
|
2) File Find! - "CleverKeys"
I have another simple little
utility that has become indispensable on the Basement desktop - CleverKeys! Here's how it works: 1) Select any word, in
almost
program, anytime. 2) Tap the CleverKeys Hotkey.
Depending upon
your configuration, your default browser will then perform one
of four options: look up the selected word on Dictionary.com;
look up the word at Thesaurus.com; perform a web search on the
word, or search for the word at Amazon.com.
Similar in function to
Goggle but with a different interface, I find that I now use
both several times a day!
Download the CleverKeys program
from www.CleverKeys.com
Return
to top
|
|
| 3) Sites-Seeing -
"Outer Space, Out of Mind, Outside the Law"
What is
Crazythoughts.com?
Well... "Is it possible for a solar car to travel faster
than the speed of light?" "Do pigs pull hamstrings?" "Do dumped
farmers get John Deere letters?" "If you decide that you're
indecisive, which are you?" No answers, just
Crazythoughts!
≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤
≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤
≥≤ ≥≤ ≥≤ ≥≤ ≥≤
I'm on my way to
Mars, or at least my name is. Care to join me? NASA invites you
to send your
name to Mars on the next Mars Exploration Rover-2003
mission!
≥≤ ≥≤ ≥≤ ≥≤
≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤
≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤
If you witness a crime, it is your
civic duty to report the crime to the police. When a crime is
committed, you have the right and responsibility to make a
'Citizen's Arrest'. Thus, if YOU commit a crime, it would be
extremely helpful (and provide a savings of tax dollars) for you
to perform a Citizen's Self-Arrest." The University of Oklahoma
Police Department wants to assist you with this effort, thus
their online
Citizen's Self-Arrest Form.
≥≤ ≥≤ ≥≤ ≥≤ ≥≤
≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤
≥≤ ≥≤ ≥≤ ≥≤ ≥≤ ≥≤
Ever questioned your sanity? Like now, as you're reading this
particular newsletter? Settle the question for good with this
Online
Insanity Test!
Return
to top |
|
| 4)
Email Funny - "Mind Reader"
"In front of you are six
different cards" - a Famous Magician will guess which one you're
thinking of!
Download this PowerPoint
slideshow that has been magically enhanced, and baffle your
friends with its ability to read your mind! You've got to see it
to believe it.
Click to download
A
PowerPoint Card Trick!
(BTW - If you can't
figure it out, I'll happily explain how it works... see the
Basement Benefactor sidebar
J
)
Return
to top
|
|
| 5)
They Said It
"If everything seems under
control, you're just not going fast enough." - Mario Andretti
Return
to top |
|
| 6)
Hodgepodge
< * >
How about a decorative pair of of wings that can be grafted on to
your back? Part pig, part human, this
biologically-engineered accessory could give you that
angelic look you've been seeking.
< * > Fantasy footballers (that's the football as known
in the rest of the world, soccer to those of us in the US) will
want to take a look at the
WorldPool2002 a
FREE online fantasy game that allows soccer fanatics the
opportunity to predict the outcome of the upcoming World Cup. < * >
"Spyware
vs. anti-spyware. The author of Ad-Aware, a program that
removes sneaky software, explains what happened when his own
program was zapped by the enemy." < * > "Despite the naive
assumption that the multiple-intelligences theory spreads the
wealth of genius among many, giftedness is still as rare a
commodity as is mental retardation." Education Week has
this revealing story of Justin, who "at the age of 6 was
tested as having an IQ of 298 (the highest ever recorded) and a
math SAT score of 800. He mesmerized a nation with his uncanny
ability to understand complex concepts that even adults found
difficult to master."
G'nite, and thanks for reading!
Dave Gretz
Return
to top
|
|
|
Dave Gretz,
Editor
|
|
-
- - - - - - - -
|
|
Basement
Links
Subscribe!
Basement Home
Past Issues
File Finds
Email Funnies
Site Reviews
E-Mail Dave
|
|
-
- - - - - - - -
|
|
Photo
Funny 
CLICK ABOVE!
Send
A Photo Funny Card!
|
|
-
- - - - - - - -
|
Search
The Basement
|
|
-
- - - - - - - -
|
Noises From
The Basement
is a BTB Management
Services publication e-published every other Wednesday and
delivered directly to your e-porch, rain or shine!
|
|
-
- - - - - - - -
|
|
Details,
Details!
You have received
this e-mail because I know you, or your e-mail address was
displayed onscreen during a Star Wars trailer at a recent showing
of Spiderman...
HOWEVER, if this does not describe you, your address was submitted
through one of the many marketing venues I use, and your request
is on record.
Subscriptions
If you
do not wish to continue receiving this newsletter, please see your
personalized message at the
very bottom of this issue.
Switch
to Text
If you
are a CURRENT HTML subscriber and would like to switch to TEXT, send a
blank email here:
I
PREFER TEXT
Change
Your Email Address?
If you wish to
change your email address reply to this message with
"Change of Address" in the subject line and include both
your old and new address in the body of the email.
|
|
-
- - - - - - - -
|
|
Recommend
Noises
 |
|
-
- - - - - - - -
|
|
Sources & Resources
places to go,
people to read
FREETECHMAILORG
Dave
Pell's
NEXT DRAFT
Steve Gibson's
GRC
Fred Langa's
LANGALIST
Tara Calishaine's
RESEARCHBUZZ
Declan McCullagh's
POLITECH
Roger D. Hodge's
HARPER'S WEEKLY
Barbara Mikkelson's
URBAN LEGENDS
Jerry Lerman's
Bonehead of the Day Award
Chris Pirillo's
LOCKERGNOME |
|
-
- - - - - - - -
|
|
So, How'd I
Do?
Let me know what
you liked or disliked in this issue of
Noises From The Basement!
E-Mail Dave
|
|
-
- - - - - - - -
|
|
Want To Be A
Basement Benefactor?
Only because I've been asked for it;
donations will be used to reduce website and newsletter related
expenses.
NFTB remains free
for all readers! |
|
|
|
|
Thanks!
Dave Gretz
"BTB Management Services" |
|
|
|