how to insert symbol or sign on the top right of any number

D

Dave Peterson

Like a superscript?

If the value in the cell is really an number, then you can't do it.

If you treat the value as text (preformat the cell as text or start your entry
with an apostrophe '1234), you can select the characters you want (in the
formula bar), then click format|Cells and check the Superscript box.



Jaun wrote:
 
R

Ron Rosenfeld

Depending on the symbol or sign, you can either use custom formatting;
concatenation; or a VBA event-triggered SUBroutine


--ron
 
G

Gord Dibben

If a number, use a Custom Format.

Type a zero the Alt + 0178 for superscript 2, 0179 for superscript 3, 0176
for the degree symbol

Note: use the numpad on right to enter the numbers.


Gord Dibben MS Excel MVP

On Wed, 9 May 2007 00:32:01 -0700, Jaun <[email protected]> wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
how to get left side zeros to show i.e. 00045 0
how to put a number with more than 15 digits in a cell 0
How do I change auto formatting to allow a 0 as the first number 0
The @ symbol 7
How to handle a minus sign "-" as text not as part of a formula? 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
end a number in ZERO 3

Top