“Numbers” utilities
Language:
In the Excel menu choose ASAP Utilities » Numbers to access these 10 utilities:
- Apply formula/calculation to selected cells... (2 screenshots »)
- Change formulas to their calculated values (1 screenshot »)
- Change not recognized numbers (text?) to numbers (2 screenshots »)
- Change values to text values (adding ' in front)
- Change negative numbers to positive and vice versa... (1 screenshot »)
- Move minus sign from back to front (e.g. 65- to -65) (2 screenshots »)
- Use a significant number of decimals...
- Convert percentages to numbers (e.g. 5% to 5)
- Spell/write out numbers or amounts (EN, DE, NL)... (1 screenshot »)
- Round numbers (not formatting, but changing)... (2 screenshots »)
Submenu screenshot
« Return to the list of tools.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 