|
|
“Numbers & Dates” utilities
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語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)
- Fill cells with their formatted value
- 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 2016, 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
© 1999-2018 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
