-----Original Message-----
From: ExcelTips [mailto:awyatt@dcomp.com]
Sent: Saturday, July 07, 2007 10:20 AM
To: samaruna@omantel.net.om
Subject: ExcelTips for 7 July 2007
Allen Wyatt's ExcelTips
7 July 2007 Copyright 2007 by SPA
**********************************************************************
In This Issue...
----------------
Publisher's Notes
Tips
* Formatted Data Appears Differently On Different Systems
* Inserting Tomorrow's Date
* Adding Buttons to Your Worksheet
* Printing Workbook Properties
Help Wanted
* Getting Rid of Alphabetic Characters
* Searching for Line Breaks
Publisher and Copyright Information
Important Links
Subscription Information
~:::~ GET YOUR NAME OUT AND ABOUT! ~:::~
Got an Excel-related product or service you want to let others
know about? Advertising in ExcelTips is a cost-effective way to
let thousands of serious Excel users know about you. For more
info, visit http://www.VitalNews.com/advertising.html
**********************************************************************
PUBLISHER'S NOTES * PUBLISHER'S NOTES * PUBLISHER'S NOTES
**********************************************************************
Today we are off attending the marriage of our youngest son, Andrew, to his
beautiful sweetheart, Holly. They are a lovely couple, getting married in
Spokane, Washington. By the time you read this they should be tying the
knot, and will always have 07/07/07 as their own.
My best to all on this fine day.
-Allen
**********************************************************************
TIPS * TIPS * TIPS * TIPS * TIPS * TIPS * TIPS * TIPS * TIPS
**********************************************************************
If you have an idea for a tip, send it our way. You can e-mail the
suggestion to allen@sharonparq.com. Any tips contributed will be credited in
the issue in which they appear.
You can learn more about each individual tip by using the links provided
below. Or, if you prefer, you can find all four of this week's tips at this
address: http://exceltips.VitalNews.com/ci.html
------------------------------
Formatted Data Appears Differently On Different Systems
------------------------------
If you notice that dates don't look the same when a workbook is opened on
different systems, it could be because of the way you have the cells
formatted. This tip explains why this difference occurs and provides some
solutions you can apply.
Read the full tip: http://exceltips.VitalNews.com/T1317
(Thanks to Khushnood Viccaji, Steve Aprahamian, and Philip Bellingham for
contributing to this tip.)
------------------------------
Inserting Tomorrow's Date
------------------------------
If you need to add tomorrow's date to a worksheet, you can do it using
simple math. The formulas provided in this tip are both illuminating and
helpful.
Read the full tip: http://exceltips.VitalNews.com/T0547
|---------------------------------------------------------------|
~:::~ RECEIVE OUR SISTER PUBLICATION! ~:::~
If you use Word, you need WordTips. Become a Word expert--learn
the tips, hints, and tricks that make the difference. Same high
quality as ExcelTips. For detailed info on this FREE weekly
newsletter, visit http://wordtips.VitalNews.com
|---------------------------------------------------------------|
------------------------------
Adding Buttons to Your Worksheet
------------------------------
You can easily add a button to your worksheet that will allow you to run
various macros. This tip shows how easy it is.
Read the full tip: http://exceltips.VitalNews.com/T0497
------------------------------
Printing Workbook Properties
------------------------------
When you take a look at the Properties dialog box associated with any
workbook, you'll notice that Excel tracks quite a bit of information about
the workbook itself. This tip shows how you can get this property
information into a worksheet so you can print it out.
Read the full tip: http://exceltips.VitalNews.com/T0509
**********************************************************************
Step up to the PROFESSIONAL version of ExcelTips--ExcelTips Premium.
This week ExcelTips Premium subscribers also learned about:
* Error Opening Second Workbook
* Numbers in Base 12
* Adding Ordinal Notation to Dates
* Determining an ANSI Value in a Macro
Each weekly newsletter is in a professional PDF layout, and presents DOUBLE
THE TIPS (Premium subscribers see articles you won't in regular
ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers
get valuable money-saving benefits. For more information, (including a
sample issue) visit the following Web page:
http://store.vitalnews.com/etprem.html
**********************************************************************
HELP WANTED * HELP WANTED * HELP WANTED * HELP WANTED
**********************************************************************
This section is for those having problems making Excel behave. You can
submit your own question by visiting this page on the Web site:
http://exceltips.VitalNews.com/questions.html
If you have a solution for the problems below, send your answer to
etanswers@vitalnews.com (all responses become the sole property of Sharon
Parq Associates, Inc., and can be used in any way deemed appropriate). If
your response is used in a future issue, you will be credited for your
contribution to the answer.
------------------------------
Getting Rid of Alphabetic Characters
------------------------------
I have a lot of cells that have some alphabetic characters in them. Is there
a way to get rid of only those characters, no matter where they appear in
the cell? For instance, if the cell contains "ABC123," I want to get rid of
"ABC" and have just "123" remaining. Similarly, "A3B2C1" should become "321"
and "#45P*%" should become "#45*%".
(Bryan Bowes)
------------------------------
Searching for Line Breaks
------------------------------
How can I search for a line break (Shift+Enter) in a cell? In Word I can
search for ^l to find line breaks; I can find no such command in Excel.
(Veronica Lee)
**********************************************************************
PUBLISHER and COPYRIGHT INFORMATION
**********************************************************************
ExcelTips is published weekly by Sharon Parq Associates, Inc., PO Box 794,
Orem, UT 84059. Copyright 2007 by Sharon Parq Associates, Inc., All Rights
Reserved. All broadcast, publication, or retransmission is strictly
prohibited without prior written permission from the publisher. Full
information on distribution rights can be found in the FAQ at the ExcelTips
Web site.
**********************************************************************
IMPORTANT LINKS * IMPORTANT LINKS * IMPORTANT LINKS
**********************************************************************
WEB ADDRESSES
-------------
ExcelTips Web site -
http://exceltips.VitalNews.com/
Vital News Store -
http://store.VitalNews.com/
ExcelTips Archives -
http://store.VitalNews.com/etarch.html
ExcelTips Premium -
http://store.VitalNews.com/etprem.html
Advertising -
http://www.VitalNews.com/advertising.html
Help Wanted questions - http://exceltips.VitalNews.com/questions.html
E-MAIL ADDRESSES
---------------
Help Wanted answers - etanswers@vitalnews.com
Editor and Publisher - allen@sharonparq.com
**********************************************************************
SUBSCRIPTION INFORMATION * SUBSCRIPTION INFORMATION
**********************************************************************
You as subscribed to ExcelTips as samaruna@omantel.net.om
ExcelTips is a Vital News publication. Vital News is a division of Sharon
Parq Associates, Inc., PO Box 794, Orem, UT 84059, USA
To unsubscribe or change subscriber options visit:
http://www.aweber.com/z/r/?TMzMDGwMtCwMDBzs7Bxs
______________________________________________________________________
This email has been scanned by the Omantel AntiVirus System.
______________________________________________________________________
No comments:
Post a Comment