Tip of the Day | Monday January 26th, 2026
Discover new tools to get things done.
Replace Values with Their Formatted Value
This 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...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ 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 26 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.