superscript in cells (excel 03′ sp2)

Topic

New Reply

Does anyone know how to apply a note number to formatted cells without adversely affecting the cell contents used in a formula calculation…i.e a cell such as A5 with the contents/number 35,236 with superscript of ^3, (designating note 3) changes the results of the function or formula.

Regards,
mojave1

Reply | Quote

Replies

That’s not possible. You could enter the note designator in a narrow column to the right of the cell.

Reply | Quote

Format cells
Number (tab)
Custom
Enter the format desired (eg #,##0)
At the end of the number hold down the the key and enter 0179 on the numeric keypad. It will add a superscript 3 to the number and it will not affect the value in the cell.

Note:
0186 is Supercript 0
0185 is Supercript 1
0178 is Supercript 2

The downside is that is the extent of them…

Steve

Reply | Quote

Steve,

thanks I’ll give it a shot…..

Marty

Reply | Quote