Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insert symbol or sign on the top right of any number
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insert symbol or sign on the top right of any number
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: -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insert symbol or sign on the top right of any number
On Wed, 9 May 2007 00:32:01 -0700, Jaun wrote:
Depending on the symbol or sign, you can either use custom formatting; concatenation; or a VBA event-triggered SUBroutine --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insert symbol or sign on the top right of any number
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 wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert symbol | Excel Discussion (Misc queries) | |||
insert a therefore symbol | New Users to Excel | |||
Means sign (symbol) | New Users to Excel | |||
insert symbol | Excel Worksheet Functions | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |