JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,718
- Office Version
- 365
- Platform
- Windows
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".
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".
Cell Formulas | ||
---|---|---|
Range | Formula | |
C7:E7 | C7 | =CONVERT(C6,"F","C") |