Can I add the degree symbol to a custom format?

[JenniferMurphy]

I often need to display values in degrees. Not finding a way to enter a degree symbol directly into a custom format string, I end up going over to Word, entering the symbol using Crtl+Shift+@, Space, then copying that to the custom format. Unfortunately, xl2bb does not include the custom formats in what it displays. The format is 0.0°F_) for the °F numbers and 0.0°C_) for the °C numbers.

Is there any way that I can enter that degree symbol (or any other ASCII symbol) directly into the custom format string? I believe the degree symbol is "0176" or "248".

Book1
	C	D	E
6	0.0°F	32.0°F	212.0°F
7	-17.8°C	0.0°C	100.0°C
Sheet1

Cell Formulas
Range	Formula
C7:E7	C7	=CONVERT(C6,"F","C")

 

[Marius44]

Hello
I think it is necessary to use the CHAR function and the code of the character °, that is CHAR (176)
(my Excel version is 2010)
Hello,
Mario

 

[JenniferMurphy]

Hello
I think it is necessary to use the CHAR function and the code of the character °, that is CHAR (176)
(my Excel version is 2010)
Hello,
Mario

OK, but where do I put it in the custom format? I tried replacing 0.0°F_) with 0.0char(176)F_), but that gets an error.

 

[Peter_SSs]

See if this helps.

 

[JenniferMurphy]

Just to be clear, here's the current custom format that works:

But I have to paste the degree symbol from Word.

 

[footoo]

Use Alt + 0176 to enter the degree symbol in the custom format.

 

[JenniferMurphy]

See if this helps.

Great, thanks. The Windows Character Map does what I need this time and more. But I don't know why Excel makes it so difficult when it's so easy in Word. I thought I read somewhere in the M$FT hype that the Office family would all use the same UI/UX! Ha!

 

[JenniferMurphy]

Use Alt + 0176 to enter the degree symbol in the custom format.

I tried that, but, if I remember correctly from my old XP system, that only works if the keyboard has a numeric keypad. That's just one of the many deficiencies of this piece of crap Surface Book. Grrrrrrrrrr...... ???

 

[footoo]

I would not survive without a numeric keypad. I use Alt + a lot (e.g. Bullets, Foreign currency symbols, etc.)
Apart from being much easier to enter amounts.

 

[JenniferMurphy]

I would not survive without a numeric keypad. I use Alt + a lot (e.g. Bullets, Foreign currency symbols, etc.)
Apart from being much easier to enter amounts.

I completely agree. I didn't check this thing out well enough. My plan is to first get an external keyboard that I like and then use that with whatever I replace this junk with. I curse this thing nearly every day.