View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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