Creating strings for legend
Or slightly simpler:
=TEXT(A2,"0")&" deg"
Hope this helps.
Pete
On Apr 27, 3:58*am, wrote:
Got it now.. the correct expression is:
* *=CONCATENATE(TEXT(A2,"0"), " deg")
* * * * * * * or
* *=CONCATENATE(TEXT(A2,"0"), " °")
where the ASCII code for the ° symbol is: *Alt+0176
* * -G
|