Click here if this e-mail does not display correctly
June 11, 2009


Publisher's Note
In 2006, there was not a single trading day when the Dow Jones industrial average rose or fell by 2 percent or more. In the first quarter of 2009 alone, there were 21 such days. That's a staggering fact, housed at the core of these turbulent times.

Speaking of numbers, readers from all over the United States wrote in about the math challenge in last Thursday's Publisher's Note. If you don't recall it, here it is. Next Thursday, we'll shed light on this oddity. There's still time to step up to the plate.

Rob Nance
Publisher
AccountingWEB, Inc.

publisher@accountingweb.com



Manufacturing in a Lean, Flat World

Summer Internships

Windows 7 RC Now Available to Us Mortals

Obama Proposes International Tax Reform


Questions & Advice

Working around #N/A

An #N/A (missing data) populates a vlookup answer cell if the information is not found in the lookup table for an exact match (and I don't want to use a fuzzy TRUE match). This error message (the #N/A) prevents that cell from being useable (columns won't add and I haven't figured out how to eliminate it with IF statements buried in the vlookup statement either). Any suggestions how to work around this dreaded missing data issue?
Add your input!

Merging Cells in MS Excel 2003

I am in the process of organizing some meeting notes using MS Excel 2003. I am using the merge cell function for my type- written notes. The problem I am having is the spreadsheet does not show the full text that I have typed in. I have utilized the autofit row height function with no luck. Can someone help me figure out how to get the full text to show on the spreadsheet?
Share your suggestions!



Archives

Visit AccountingWEB's complete archives, and current quiz by following the links below:

E-Newsletters, Supplements, and Audio Features

This week's CPA review

Featured links
Gear Up Tax & Accounting Education - Conferences, Live Seminars, Self-Study CPE
Offering payroll services is more profitable than ever for accountants
Preserve and Pass On Wealth - Estate Planning from CCH Audio Seminars
Everything in this e-newsletter is created with your needs in mind,
assisting you with information and choices for your accounting life.
Top News

Will multinational corporations survive the coming tax changes?

Why are business groups, including the U.S. Chamber of Commerce, spitting nails after President Obama's announcement of tax changes on Monday May 4th? more >>

Why the secrecy? Public disclosure of taxes not a new idea
Synopsis of the above article goes here.
CFOs divided over need for IFRS
Synopsis of the above article goes here.
CCH - a Wolters Kluwer business
Gear Up Tax & Accounting Education - Conferences, Live Seminars, Self-Study CPE

Over 35 years of delivering practical information you can use, taught by the best in the business.

This summer, join us July 27 - August 2 for Windy City Week in Chicago - Register by June 16 for Early Bird Savings! Plus, save with a discounted $139 room rate (through 6/26) at the beautiful Crowne Plaza Chicago Metro Hotel. Select from: Compilation and Review, Forensic Accounting & Auditing Techniques, Accounting Update, Technology 2.0, Mid-Year Tax Update for Individuals (new!), Planning for Later Years in Life, Estates & Trusts Update, and IRS Audits, Appeals, and Collections.

Or opt for a fall getaway at Royal Flush in Las Vegas (Nov 30 - Dec 1) or Magic Week in Orlando (Dec 15 - 19)!

And don't miss out new Mid-Year Tax Update seminar...This hot new course is earning rave reviews from attendees, and is only available through July 2009!

Visit trainingcpe.thomson.com/GearUp or call 800.231.1860.
Featured Articles
A Conversation with John Sharbaugh of the Texas Society of CPAs

When you're born in Hershey, Pennsylvania and grow up in a town close enough that you can small the chocolate whenever the wind blows, you just know that the future can only be bright. Of course, John Sharbaugh attributes his successful career in association management more to his education and his penchant for preparation than to having chocolate in his DNA, but a case could be made either way. more >>
Why the secrecy? Public disclosure of taxes not a new idea
Synopsis of the above article goes here.
CFOs divided over need for IFRS
Synopsis of the above article goes here.
How automation and the internet make offering payroll hassle free and profitable for accountants

Accountants can now use the same kind of powerful processing center the payroll bureaus have kept to themselves for decades. The Internet has made technology used by large payroll service bureaus such as ADP within reach of accountants. Now, accountants can private label Payroll Service, control 100% of their client relationship, and make $30,000 to $50,000 per year in additional revenue.
Firm/State/People News
BBD team will head to Kentucky to rebuild housing for the elderly

On Sunday May 31, nearly half the personnel of Briggs, Bunting & Dougherty LLP (BBD), a CPA firm in Philadelphia, Pennsylvania, will be making the nine-hour drive to Salyersville, Kentucky to begin a community service project that will entail working four full days remodeling homes for the elderly. more >>
Why the secrecy? Public disclosure of taxes not a new idea
Synopsis of the above article goes here.
CFOs divided over need for IFRS
Synopsis of the above article goes here.
CCH - a Wolters Kluwer business
Upcoming CCH Audio Seminars
Earn CPE Credit - Train your Staff


CCH's live, two-hour interactive audio seminars require nothing more than a telephone connection. One low fee covers an unlimited number of listeners. Support materials are included. Earn CPE while you learn.

FEATURED AUDIO SEMINARS:

Introduction to Estate Planning - June 16

Planning for Intermediate-Sized Estates - June 18

Complete List of Upcoming CCH Audio Seminars
Advertise in the Weekly News Analysis E-Newsletter
Many advertising opportunities are available
Contact Diane Williams, Sales Manager
866-688-1678 x 17 or e-mail dwilliams@accountingweb.com

Has Outlook blocked your images?
If you need to right-click one of the images in this e-newsletter to see the pictures it's easy to set up AccountingWEB.com as a 'safe sender' so you don't have to do this every time you receive an e-newsletter. Select the Actions-Junk Mail menu and pick either the 'Add Sender' or 'Add Sender's Domain' option.
You are currently subscribed as: ##email##

To unsubscribe from from the Weekly News Analysis, Click Here.
If you experience any problems, please Contact Us

Click Here to swap to the 'Text-Only' version, change your e-mail address, your password information, modify subscriptions, and update your personal profile information.

Please allow up to ten (10) business days for unsubscribe orders to be processed. Thank you for your patience.

© Copyright 2009 AccountingWEB, Inc. All rights reserved.

AccountingWEB.com
P.O. Box 2252, Westerville, OH 43086-2252
"Your Profession. Your Community."

Powered by


The AccountingWEB Portfolio includes:

AccountingWEB.com | AccountingWEB.co.uk | AccountingWEB.nl