Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a macro to use the degree symbol and it runs
well until I enter a number. When a number is entered, the degree symbol will not operate. How do I need to develop the macro to function and display a value with the degree symbol (90°)? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Without seeing your code I can only guess you need to
concatenate the number(which I assume is a variable) and the degree symbol It would look something like this mynumber & "°" -----Original Message----- I created a macro to use the degree symbol and it runs well until I enter a number. When a number is entered, the degree symbol will not operate. How do I need to develop the macro to function and display a value with the degree symbol (90°)? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |