“Numbers & Dates” utilities

Language:

In the Excel menu choose: ASAP Utilities » Numbers & Dates

Apply formula/calculation to selected cells...
Change formulas to their calculated values
Convert unrecognized numbers (text?) to numbers
Change values to text values (adding ' in front)
Change negative numbers to positive and vice versa...
Move minus sign from back to front (e.g. 65- to -65)
Use a significant number of decimals...
Convert percentages to numbers (e.g. 5% to 5)
Spell/write out numbers or amounts (EN, DE, NL)...
Round numbers (not formatting, but changing)...
Fill up with leading zeros...
Quick numbering of selected cells...
Random numbering of cells (without duplicates)
Convert/recognize dates...
Change Julian dates to normal dates

Submenu screenshot

Excel 2013, 2010 or 2007 with ASAP Utilities in its menu: Numbers & Dates

Excel 2003, 2002/XP or 2000 with ASAP Utilities in its menu:

« Return to the list of tools.

Follow ASAP Utilities on Facebook

Printer friendly page

Connect with us and receive our "tip of the week" at:

	Home Screenshots Download Buy Now Search About Contact Us Blog

	Download License Agreement Download ASAP Utilities (recommended) Upgrade to the latest version Version history Compare versions Alternative download options System requirements Upgrade once a year (Home&Student ed.) Download ASAP Utilities for Excel 97 Purchase Buy Now Payment Methods Pricing and volume discounts Sales, upgrades and Refunds Policy When to buy a license License Agreement Example of the ordering process + help What is it? What is ASAP Utilities Screenshots of ASAP Utilities The primary goals of ASAP Utilities About the author of ASAP Utilities System requirements Nederlands: Makkelijker werken in Excel Examples of how to use ASAP Utilities Why use it? Top reasons to use ASAP Utilities Features Descriptions of all tools in ASAP Utilities Search within the ASAP Utilities tools Added worksheet functions Fully expanded list of all menu items Some screenshots of ASAP Utilities Examples of how to use ASAP Utilities Video tutorials Testimonials Testimonials, feedback from users Reviews from the press Clients, who uses ASAP Utilities? User Guide Download the User Guide How to install ASAP Utilities Detailed step by step installation How to uninstall ASAP Utilities Examples of how to use ASAP Utilities Video tutorials News Latest news RSS Feed Receive our Newsletter Unsubscribe from our Mailing List Excel tips Excel tips Excel keyboard shortcuts overview Headlines from the best Excel weblogs Links to interesting websites Recommended Excel books Excel version screenshots Support 1. FAQ: Questions and answers 2. Search within our website 3. Version history 4. Bug report guidelines 5. Sitemap 6. Contact us
	Home Features"Numbers & Dates" utilities
	List of tools A description of all tools in ASAP Utilities Find a utility Search in the descriptions of all tools in ASAP Utilities “Numbers & Dates” utilities Language: In the Excel menu choose: ASAP Utilities » Numbers & Dates Apply formula/calculation to selected cells... Change formulas to their calculated values Convert unrecognized numbers (text?) to numbers Change values to text values (adding ' in front) Change negative numbers to positive and vice versa... Move minus sign from back to front (e.g. 65- to -65) Use a significant number of decimals... Convert percentages to numbers (e.g. 5% to 5) Spell/write out numbers or amounts (EN, DE, NL)... Round numbers (not formatting, but changing)... Fill up with leading zeros... Quick numbering of selected cells... Random numbering of cells (without duplicates) Convert/recognize dates... Change Julian dates to normal dates Submenu screenshot Excel 2013, 2010 or 2007 with ASAP Utilities in its menu:Excel 2003, 2002/XP or 2000 with ASAP Utilities in its menu: « Return to the list of tools. Follow ASAP Utilities on Facebook
	Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top © 1999-2013 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands Connect with us and receive our "tip of the week" at: