The ASAP Utilities menu in Excel (English)
Replace Values with Their Formatted Value
ASAP Utilities › Numbers & Dates › 5. Replace Values with Their Formatted ValueThis tool replaces the actual values in the selected cells with their displayed (formatted) values, preserving how they appear in Excel. For example, if a cell contains the number 123 but is formatted to display as "00123," this tool changes the cell's value to "00123".
Similarly, if a phone number is stored as 15551234567 but is formatted to display as "+1 (555) 123-4567," the tool replaces the underlying value with the formatted phone number.
This guarantees that when you use the data, for example, in a Mail Merge in Word, it is displayed exactly how it looks in Excel. This tool can be helpful when you need to preserve the appearance of custom-formatted data such as phone numbers, ZIP codes, or dates.
Screenshots
Example screenshot: Fill cells with their displayed value
Starting this tool
- Click ASAP Utilities › Numbers & Dates › 5. Replace Values with Their Formatted Value
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
Replace cell values with displayed value, Convert raw values to formatted text in Excel, Replace values with formatted output, Change cell content to formatted value, Convert cells to their displayed format, Preserve number formatting as value, Replace numbers with formatted text, Convert phone numbers to formatted text, Paste formatted values only in Excel, Convert ZIP codes to formatted values, Excel custom formatted value conversion, Replace formulas with their displayed result, Replace cell values for mail merge
Replace cell values with displayed value, Convert raw values to formatted text in Excel, Replace values with formatted output, Change cell content to formatted value, Convert cells to their displayed format, Preserve number formatting as value, Replace numbers with formatted text, Convert phone numbers to formatted text, Paste formatted values only in Excel, Convert ZIP codes to formatted values, Excel custom formatted value conversion, Replace formulas with their displayed result, Replace cell values for mail merge
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Insert Leading Apostrophe to Store Numbers as Text |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.