Use AutoCorrect to enter special symbols in Microsoft Excel

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube