ADD TEXT TO NUMBERS CUSTOM FORMATTING EXCEL INSTALL

ADD TEXT TO NUMBERS CUSTOM FORMATTING EXCEL INSTALL

You may also need to install the Character Map using Windows Setup program if you cannot find it on your system.) When using the Character Map, you can select a symbol and see in the lower-right corner of the program window what the numeric keypad shortcut key is for the character. It may differ on your version of Windows. (On my Windows XP system, I can access the Character Map accessory by choosing Start | All Programs | Accessories | System Tools | Character Map. In that case, you will need to use the Windows Character Map accessory to figure out what shortcut keys to use to get the results you want. If you are using some other font, the character codes to create the superscripted numbers may be different. To add text to a numerically formatted cell, right click on the cell and select 'Format Cells'. These shortcuts work if you are using the Arial font in your worksheet, which is the default. Simply use the following shortcuts, where you hold down the Alt key as you type the numbers on the numeric keypad: Superscript

However, when I used 15 as the ID number to test a number greater than 10 I received the following string: TO01. Next I tried 'TO01-'yyyy'-'General Excel took the formatting. Next I tried 'TO01-'yyyy'-'000 Excel didnt take the formatting. Using these characters you can easily insert superscripted numbers, as long as they are the numbers 0, 1, 2, or 3. What I tried in the custom format field was: 'TO'TEXT(A1)'-'yyyy'-'000 Excel didnt take the formatting. The answer is to use some of the special font characters available to Windows users.

What if you want to place a superscript in your custom formats? This menu option is not available when you are defining custom formats, however. You use the Cells option on the Format menu to make these font modifications. When working in Excel, you can easily format text so that it contains superscripts, subscripts, or whatever other formatting tricks you want.

Add text to numbers custom formatting excel