Expiration Dates on Gift Certificates in California

courtesy of www.groupon.com...

"...it’s illegal for gift certificates (including discounted gift certificates like those offered on groupon) to have expiration dates.

more info: http://www.dca.ca.gov/publications/legal_guides/s-11.shtml

fine print:

1) most gift certificate will say “expires x/y/z unless in california”, but even if they don’t have the “unless in california” wording, the businesses aren’t allowed to enforce the expiration date.

2) if the gift certificate call the expiration dates “redemption dates” instead, the businesses have the option of giving you a refund instead of accepting the gift certificate."

Google Map Search 'Near'

Peet's Coffee and Tea loc: Los Angeles

Search - Boolean

BAC- -(BAC-AT-)

Finds all with "BAC-"
but not "BAC-AT-"

Blackberry - Save Attachments to Media Card

< This is not resolved. >
< Have not found a resolution.  You? >


"Whenever I get an email with an attachment I click on the attachment and I have two options *open or Download* I choose download and then select the documents folder on the media card. Once I have downloaded that attachment if I ever go back to that email and click on attachment again it will only give you the open option."



http://forums.crackberry.com/f86/can-i-save-documents-media-card-175488/

Text Message from Verizon Cell#

Send a text message on your Verizon service from your PC

Excel | Select Visible Cells Only

Select the area you want to copy. Press F5 click Special, click visible cells only click OK. Copy, then paste where you want.

http://www.mrexcel.com/forum/showthread.php?t=27706

There is a toolbar button for visible cells only if you use it lots:

In MS Excel 2007, to add the Select Visible Cells Command, do the following steps:
Step 1: Right click on the toolbar on top and click Customize Quick Access toolbar.
Step 2: Under Choose Command From drop down menu

, select Commands Not in the Ribbon.
Step 3: Scroll down and click on Select Visible Cells.
Step 4: Click on Add and OK.
Now you should be able to see the command in the quick access toolbar.

http://www.lytebyte.com/2008/02/08/how-to-select-and-copy-only-visible-cells-columns-or-rows-in-ms-excel-2007-and-2003/

Excel: How to Create a Formula to Correctly Evaluate Blank Cells

If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. For example, if you have the following formula in cell A1

=IF(B1=0,"zero","blank")

and B1 is blank, the formula returns "zero" and not "blank" as expected. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, as in the following example:

=IF(ISBLANK(B2),"blank",IF(B2=0,"zero","other"))

Note that the above formula returns "zero" if there is a zero value in the cell, "blank" if the cell is blank, and "other" if anything else is in the cell. You must always use the ISBLANK formula first before you test for a zero value. Otherwise you will always return a "true" for the zero value, and never get to the test for the ISBLANK formula.

Add or Remove "Welcome Center" at Startup (Microsoft Vista)

Control Panel > System and Maintenance > Welcome Center

and check (or uncheck) the box "Run at startup

NYTimes: Q & A: Speeding Up a Slow Windows Startup

http://gadgetwise.blogs.nytimes.com/2009/05/07/q-a-speeding-up-a-slow-windows-startup/

Add Facebook status to FriendFeed? - Yahoo! Answers

Add Facebook status to FriendFeed? - Yahoo! Answers: "How do I add my Facebook status feed to FriendFeed? I always get this error 'It appears that Facebook does not provide a Status feed for your account'!"