|
|
You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語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, NL)".
Starting this utility
In the Excel menu choose: ASAP Utilities » Numbers & Dates » Change values to text values (adding ' in front)« Return to the list of “Numbers & Dates” tools.
| « Previous Convert unrecognized numbers (text?) to numbers | Next » Fill cells with their formatted value |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utilities
Additional keywords for this tool:
textnumbers
textnumbers
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:
