Numbers & Dates

Excel  › ASAP Utilities › Numbers & Dates

  1. Apply Calculation to Selected Cells...›

  2. Convert Formulas in Selection to Static Values›

  3. Convert Numbers Stored as Text to Real Numbers›

  4. Insert Leading Apostrophe to Store Numbers as Text›

  5. Replace Values with Their Formatted Value›

  6. Change Number Signs: Reverse or Make All Positive or Negative...›

  7. Fix Trailing Minus Sign: e.g., Convert 50- to -50›

  8. Show a Significant Number of Non-Zero Decimals...›

  9. Convert Percentages to Numbers (e.g., 5% to 5)›

  10. Spell Numbers or Amounts in Words...›

  11. Permanently Round Numbers Without Using Formulas...›

  12. Add Leading Zeros to Reach Specific Length...›

  13. Auto Numbering and Labeling of Selected Cells...›

  14. Insert Unique Random Numbers›

  15. Convert Text Dates to Usable Excel Dates...›

  16. Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates›

  17. Insert Date Using a Calendar Popup...›

ASAP Utilities  ›  Numbers & Dates
Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

Clean up and convert numbers and dates in Excel. Fix imported numbers, including numbers stored as text or with incorrect negative signs. Perform calculations, round values, and convert text dates into usable Excel dates. You can also insert dates using a calendar.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 29,000+ organizations.

300+

Time-Saving Excel Tools

The tools in ASAP Utilities help you save time and do what Excel alone can't.

10

Languages

Available in 10 languages. It works with all Excel and Windows language versions. Used by clients in over 140 countries.

38

Extra worksheet functions

Easy-to-use functions that extend Excel's capabilities, such as counting or summing cells by fill or font color.

Get Started with ASAP Utilities 9

Start saving time in Excel with practical tools you can use right away.

Download See What You Can Do

  • No sign-up required.

  • Free 90-day trial