ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format Cell to show "-1" in subscript (https://www.excelbanter.com/excel-discussion-misc-queries/89465-format-cell-show-1-subscript.html)

PCH

Format Cell to show "-1" in subscript
 
I want to format a number to "-1" in subscript.

I know "alt + 0178" produes "2" and "alt + 0179" produes 3 so i've tried
"alt + 0177" which only produced some wiggly lines.

Any ideas any one?





RaymundCG

Format Cell to show "-1" in subscript
 
Hi!

Still yet to discover some alternative keystrokes to do this but for now you
may do this manually by:

After entering the -1 value/as text, select the cell then Format then Fonts
tab then checking the subscript box then OK

Hope this helps!

--
Thanks and kind regards


"PCH" wrote:

I want to format a number to "-1" in subscript.

I know "alt + 0178" produes "2" and "alt + 0179" produes 3 so i've tried
"alt + 0177" which only produced some wiggly lines.

Any ideas any one?






All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com