ASAP Utilities, description of our Excel tools![]() Numbers & Dates » Change values to text values (adding ' in front)This utility changes all numbers in the selected cells to text values.This is done by placing an apostrophe (') in front of each value. Cells with formulas that have a numeric result will be filled with their calculated values. Cells with text or a date are skipped. Remark: If you want to spell out numbers you can use the utility "Spell numbers or amounts (EN, DE, FR, NL)". Starting this utilityIn the Excel menu choose: ASAP Utilities » Numbers & Dates » Change values to text values (adding ' in front)« Return to the list of “Numbers & Dates” tools.
You can do this too![]() Download "The one essential add-in for all Excel users." Additional keywords for this tool: textnumbers | ||
Home
Privacy Policy
Cookie Policy
EULA
Sitemap
Search
List of all utilities
Printer friendly page
Contact Us
^ Back to Top
© 1999-2021 - 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:
![]() ![]() |