|
|
In my workbooks, I sometimes add buttons to run macros. Usually, they're for navigation to the next or previous sheet, or to run a macro that's specific to the contents of the worksheet.
In this example, I've got two macros in the workbook – one that takes you to the next sheet in the workbook, and one that takes you to the previous sheet. So, if you're on the second sheet, you can click the Next button to go to the third sheet. Or, click the Back button to go to the first sheet.
Add a Button On the Ribbon, click the Developer tab Note: If the Developer tab isn't visible, click the Office Button, then click Excel Options. Click the Popular category, then add a check mark to Show Developer tab in the Ribbon. In the Controls group, click Insert, to see the controls from the Form toolbar and
Continue reading Run an Excel Macro With a Worksheet Button
Excel hasn't been around for 40,000 days, but Excel's date system starts at January 1, 1900 (day 1), and today is day 40,000. Not for Mac users though – its default date system starts at January 1, 1904 (day 0), so you won't hit this milestone for another four years. The two dating systems are explained in the Microsoft Knowledgebase article: Description of the differences between the 1900 date system and the 1904 date system in Excel. Switch to a Different Date System Whether you're using Excel on a Windows machine or on a Mac, you can switch from the default date system. Follow these steps to switch to the 1904 Date System in Excel 2007: Click the Office Button, then click Excel Options Click the Advanced category Scroll down to the section titled, When calculating this workbook Add a check mark to Use 1904 date system. Click OK
Continue reading Celebrating Excel Day 40000
Moved to the Excel Twitters archive: Excel Twitters 20090703
Who's visiting Excel blogs and websites? Chandoo, at Pointy Haired Dilbert, reported his stats for June 2009, and a few more people chimed in. The Spreadsheet Page Daily Dose of Excel PTS Blog And here are the stats for my Contextures website (blog not included) And this blog -- I lost a couple of days of stats when I switched blog themes. ________________________
What danger lurks in the evil spreadsheet? Drama and tension in outer space!
No, Excel shouldn't change your numbers, but it can happen occasionally, as this poor guy discovered.
Numbers in General Format
As the robot in the video mentioned, you might have problems if you try to enter a large number in Excel. For example, I've entered a 16-digit credit card number -- 1234567890123456 -- in cell A2.
Everything looks fine, until I press the Enter key.
The cell is formatted as General, which will only display 11 numeric characters. Since the credit card number is larger than that, it appears in exponential notation.
Significant Digits in Number Format
To make the credit card number display correctly, I could try Number format, with zero decimals.
That looks better, except that the last digit has changed from a 6 to a 0. Excel only retains 15 significant digits,
Continue reading Excel Ate My Numbers
|
|
Recent Comments