» Use AutoCorrect to enter special symbols in Microsoft Excel
CATEGORY - Excel Style
VERSION - All Microsoft Excel Versions
Example- Enter the "Euro" sign
In the cell, enter the formula =CHAR(128), press F2, and then F9 (Paste Special, Values).
Copy the "euro" sign from the Formula Bar by using the Ctrl+C shortcut.
From the Tools menu, select AutoCorrect. In the Replace box, type "euro", and in the With box, press Ctrl+V (Paste).
Click Add, and click OK.
To check this - in any cell, type the word "euro."
The text changes to the "euro" sign.
Book Store:
Recommended Books:
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Excel VBA Programming for the Absolute Beginner
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Microsoft Windows XP Inside Out
No comments have been submitted.
