View original (French)

Set unit in Open Office Calc.

Solved
dylanh72 Posted messages 44 Status Member -  
Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   -
Hello,

I would like to create a table with different temperatures, but I want a way not to rewrite "°C" in each cell. How can I do that?
Thank you for your responses.

Configuration: Windows 7 / Firefox 4.0.1

4 answers

  1.
    mic13710 Posted messages 1165 Registration date   Status Member Last intervention   360
     
    Select the relevant cell(s).
    Format / Cells / Numbers - Category: Custom.
    In "Format description" write #" °C" or #.#" °C", or whatever you want for numbers (with or without decimal), then validate.

    --
    Michel
    10
  2. pépé35530 Posted messages 2951 Registration date   Status Member Last intervention   1 390
     
    Hello,

    You should have a "custom format" option in the formats. You can then create your own format.

    See you later

    grandpa
    0
  3. dylanh72 Posted messages 44 Status Member
     
    Hello, thank you for your responses. I just have one last question:
    As you have seen, I am keeping a weather history and I added images for each weather type (sun, cloud, rain ...). I would like to count the number of each image in order to estimate the number of sunny days, for example.
    Thank you in advance.
    0
    1. Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   17 485
       
      Not possible.

      ... except maybe by macro?
      0
  4. mic13710 Posted messages 1165 Registration date   Status Member Last intervention   360
     
    Hello dylanh72.
    I believe the original question has been resolved.
    As I don't have much time to devote to the forum in the coming days, I am unable to look into your new question, which would require in-depth research (I hardly use OO).
    Therefore, I suggest you mark the topic as resolved and open a new specific discussion thread.
    --
    Michel
    0