Results 1 to 3 of 3

Thread: How to get degree symbol (Celsius) in each cell of Excel

  1. #1
    Join Date
    Feb 2012
    Posts
    10

    How to get degree symbol (Celsius) in each cell of Excel

    Is it possible to automatically get a degree symbol in a celcius once a type a number. It is possible with currency etc. under format cell and then number but I can't find temperature anywhere. Thanks in advance for the help.

  2. #2
    Join Date
    Aug 2011
    Posts
    540

    Re: How to get degree symbol (Celsius) in each cell of Excel

    Let's say that in A1 we have 30.123456 this is a little more than 30 degrees. In A2 put =A1/24 and format A2: Format > Cells... > Number > Custom and enter [hh]°mm'ss\" in place of General to see: 30°07'24".

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: How to get degree symbol (Celsius) in each cell of Excel

    Try this: Select the cells to be impacted. From the Excel main menu: <format><cells><number tab> Category: Custom
    • Type: enter the word: General
    • then hold down the [alt] key
    • type 0176...release the [alt] key
    • type a space
    • type C
    • Click the [OK] button

    That will make 21.5 display as: 21.5° C. Or else you can use the character map, copy the symbol. format cells use custom and paste as follows #,##°.

Similar Threads

  1. Need help on Typing the degree symbol iPhone 4S
    By RaviNath in forum Portable Devices
    Replies: 5
    Last Post: 17-04-2012, 06:33 PM
  2. Applying absolute cell referencing to many cell in Excel
    By Nyota in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 07:23 PM
  3. Replies: 4
    Last Post: 25-01-2012, 05:00 PM
  4. How to add new currency symbol in Microsoft Excel
    By Talisha in forum MS Office Support
    Replies: 2
    Last Post: 05-01-2012, 05:58 PM
  5. Replies: 2
    Last Post: 04-01-2012, 06:54 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,724,007.44095 seconds with 17 queries