How do I insert the degree symbol in a column of numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers on the format ddmm.mmm and would like to insert a
degree symbol after the dd. I can do it one cell at a time. Can I do the
whole column at once somehow?
 
Are you simply constructing text strings? In a helper column, use a
formula like

=LEFT(A1,2)&"°"&RIGHT(A1,6)

This assumes that there are no items with only one digit in the degrees
part of the string. Hold down Alt while typing 0176 to get the degree
symbol.

You can then copy this range, select the original range, and use Edit
menu > Paste Special > Values to put the new text into those cells.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
for general display purposes (to cover other formats too) perhaps
=TEXT(A1,"dd")&"°"&TEXT(A1,"mm.mmm")
might be better.

You would need to do this in a new inserted column B and Hide column
 
Back
Top