Number formats in Excel

  • Thread starter Thread starter Carl L. Toles
  • Start date Start date
C

Carl L. Toles

Hello all,

I am working on a spreadsheet that list uniform sizes for personnel in the
company.

In one cell I have the Short Sleeve Shirt size, say 16-16 1/2. I want the
1/2 superscripted (just looks better this way) I have figured out that if I
use ##-## ?/2 and I type 1616.5 it will give me the format that I want,
however I have not been able to figure out the superscript of the 1/2, I
tried to put [superscript] in front of the ?/2 and it would not accept it.

Anyone have any ideas?

Thanks
 
Ok, I figured out an easier way to do this by using the COUNTA function.
That way I don't have to change all the cell formats.

Sorry
 
Carl

Format>Custom ##-## <ALT + 0189>

i.e enter ##-##<space if desired> then hold ALT key and type 0189 on
NumPad(not regular number keys above qwerty)

Enter as 1616 and you will get 16-16 1/2 with the 1/2 "sort of" superscripted.

Gord Dibben Excel MVP
 
Back
Top