View original (French)

Excel 2003 cell

Solved
map -  
Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   -
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 Posted messages 27 Registration date   Status Member
     
    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
  2. Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   17 480
     
    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
    0
  3. map
     
    Is it possible with Open Office? If so, can Microsoft Office and Open Office coexist?
    0
  4. just1xpa2 Posted messages 37 Registration date   Status Member Last intervention   196
     
    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...
    0
    1. maxou157 Posted messages 354 Registration date   Status Member Last intervention   112
       
      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
      0
    2. Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   17 480
       
      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
      0
  7. 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?
    0
    1. maxou157 Posted messages 354 Registration date   Status Member Last intervention   112
       
      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
      0
  8. map
     
    great very well thank you very much for all your ideas
    see you +++ :) kisssssssss
    0
  9. Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   17 480
     
    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
    0
    1. maxou157 Posted messages 354 Registration date   Status Member Last intervention   112
       
      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
      0
  10. Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   17 480
     
    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
    0