View original (French)

Excel 2003 cell

Solved
map -  
Hello,

So I am looking for a way to convert the unit of measurement for the cells. That is to say, when I go to format/column/width, it shows me a default value of 10.71 that I don't understand, and I would like to convert this unit to centimeters.
Thank you very much 
Configuration: Windows XP Firefox 3.0.1

9 answers

  1. verbatim14
    Hello,

    In Format, Column, then Standard Width, you can enter the number you want. 10.71 is the standard width defined by Excel; this width is supposed to represent the number of standard characters that can fit in a cell...

    As for converting the width to cm, I don't know.

    See you soon.
    1. Raymond PENTIER Contributor
      Impossible. For your information, these are not French length units.
      10.71 corresponds to 80 pixels and approximately 2.243 cm.
      --
      Retirement is great! Especially in the Caribbean… :-)
      Raymond
      1. map
        Is it possible with Open Office? If so, can Microsoft Office and Open Office coexist?
        1. just1xpa2
          hello a little table maybe.....
          https://www.cjoint.com/?ivq0TBsvhn

          for your information thanks raymond

          --

          When the foundation is healthy, those who intervene behind you are happy
          on the contrary, they curse you...
          1. maxou157
            Well... I notice that the values are not the same in Excel 2007...

            And in this one, the Map issue is resolved: you can see the correspondence in mm in "View - Page Layout"!
            --
            "To speak a lot and to speak about something are not the same thing." Sophocles
          2. Raymond PENTIER Contributor
            Good idea, your table. But since the correspondences in Excel are approximate, it's better, to improve accuracy, to start from the maximum value: a column cannot exceed 255 pixels in width, which corresponds exactly to the format 1790 and is roughly equivalent to a dimension of 16.7 cm.
            Hence your modified table: https://www.cjoint.com/?ivrEkr6UZ6
            Best regards.
            --
            Retirement is great! Especially in the Caribbean... :-)
            Raymond
        4. map
          Thank you for the 2 value tables, they will be useful to me, that's nice :)
          So, if I want to have the precise unit in cm, do I need Excel 2007?
          1. maxou157
            I think so, yes...

            Here’s what it looks like: http://img137.imageshack.us/img137/3254/snap1wb5.jpg

            --
            "Talking a lot and talking about something are not the same thing." Sophocles
        5. map
          great very well thank you very much for all your ideas
          see you +++ :) kisssssssss
          1. Raymond PENTIER Contributor
            map,

            WARNING > obtaining an exact width, even with Excel 2007, is not guaranteed: depending on the printer used, there may be horizontal and/or vertical distortions.
            --
            Retirement is great! Especially in the Caribbean... :-)
            Raymond
            1. maxou157
              Oh no Raymond...

              Excel 2007 manages the size data in relation to your printer... no distortion possible!

              I often use the precise layout: it’s much more convenient than before! You can imagine a layout and already apply it in reality in the excel sheet... excel slow!

              --
              " Speaking a lot and speaking about things are not the same thing. " Sophocles
          2. Raymond PENTIER Contributor
            Ah! Wonderful: Maxou is bringing me information I didn't have yet. This is very good news for all Excel users, as it wasn't the case before.
            Therefore, map, you can go for it...
            Thank you very much, Maxou.
            --
            Retirement is great! Especially in the Caribbean... :-)
            Raymond