Rover

windows newsletter

250,000+ readers!

navigate
         
Home
Articles Archive

Search

 
 
 

About

 
Free Reports
Windows Tutorials
 

Subscribe

 
 
Subscribe free using the form below!




 
Enter Unlock Code
 
Advertise
 
     
More or Less in MS Excel
by Carol Bratt on 20080313 @ 07:27AM EST | google it | send to friends
Channel: Windows | Carol's Corner Office | (related terms: ms excel, places, decimal)
 
   
   
   
 
   

Not everyone who uses MS Excel is a 'Power User'. Everyone has to start someplace, though, and sometimes all those icons on the toolbar are a bit overwhelming. Sometimes you will find that you have been using MS Excel for months and it has never occurred to you to see what those icons do so I am going to tell you about a couple today that can prove to be very, very useful to you.

Follow along with the steps below:

  1. Launch MS Excel if it is not already open.
     
  2. Look at your Formatting toolbar.
     
  3. In MS Excel 2007, look on the Home ribbon.
     
  4. Find the button with the zeros and arrows.
     
  5. The button on the left will add decimal places to numbers in highlighted cells.
     
  6. The button on the right will reduce the number of decimal places in highlighted cells.

You may notice that as you decrease decimal places, the value displayed in the cell is rounded. Be not afraid though; if you glance at the Formula bar you will see that Excel still has the exact value stored in its memory.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

--

Related newsletter articles:

2007/12/17 Add Autonumbering to your MS Excel Spreadsheet (ms excel)
2008/01/30 Selecting Text in MS Word (button)
2006/02/10 Remove Winfixer (Removal Instructions) (button)
2006/05/18 Remove SpywareQuake (Removal Instructions): Simplified (button)
2005/09/07 Can't Uninstall / Remove PC Mighty Max? (button)
2008/03/11 Add Option Buttons to MS Excel Worksheet (button)
2007/01/31 Use GoTo to Locate Text in a Document: MS Word (button)
2007/08/21 Open a Web Page from a Toolbar in MS Office (button)
2007/06/21 iPhone Onscreen Keyboard Sparks Debate (button)
2008/03/05 Ruler Preferences in MS Word (ms)
2007/02/13 New Excel Attack Threatens Office (excel)
2008/01/22 Microsoft Reveals Excel Security Risk (excel)
2006/07/19 Using the Office Assistant: MS Excel (button)
2007/02/20 Record and Run a Macro in MS Word (button)
2007/11/09 Keep Word Commands Handy With Office 2007's Quick Access Toolbar (button)
2008/02/01 Quickly Jump Between Documents in MS Office (ms)
2007/05/17 Microsoft's Latest Fiasco: Reader Response (ms)
2006/07/13 MS Excel Security Leaks Becoming Flood (excel)

--

Recent articles (from all channels):

2008/05/09 Today in History: for Friday, May 09, 2008
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
2008/05/07 Yahoo Adds Security Warnings To Search Results
2008/05/07 Apple to Lose Money on iTunes Movie Releases
2008/05/07 Amazon.com takes New York Tax to Court
2008/05/07 Need Glasses for the Slide Sorter View in MS PowerPoint?
2008/05/07 After Winning The DVD Format War, Blu-Ray Sales Tank
2008/05/06 [ShellX 20080506]: 'Visual Basic 6.0 Portable', and 'Double-...
2008/05/06 Yahoo Outsources to Jajah
2008/05/06 New HP Circuit Could Change Technology Forever
2008/05/06 Movie Downloads To Match DVD Release Dates
2008/05/06 Microsoft Ends Yahoo Bid
2008/05/05 [ShellX 20080505]: 'Ie7 Pro', and 'Desktop Ok'
2008/05/05 The WB Network Hops Online
2008/05/05 Microsoft Slashes Price of Xbox 360 Overseas
2008/05/05 Google CEO Wants YouTube to Take More of Your Money
2008/05/05 Finding Items in MS Outlook's Reading Pane
2008/05/02 [ShellX 20080502]: 'Software Virtualization Solution', and '...
2008/05/02 Rogers Brings iPhone to Canada
2008/05/02 New Google Tool Cuts Down Irrelevant Image Search Results



--

Subscription Management

To subscribe to our newsletter, or to read past issues:

http://www.infopackets.com/windows+newsletter.htm

To remove or change your subscription information, visit:

http://www.infopackets.com/remove+change+email.htm

         

 

Home | Subscribe | Remove | Download | Advertise | Contact | Refund Guarantee | Privacy Policy
Copyright © Computer 411 | Infopackets.com.  All rights reserved.