Excel 2003 cell
Solved
map
-
Raymond PENTIER Posted messages 58208 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58208 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
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
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.
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.
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
10.71 corresponds to 80 pixels and approximately 2.243 cm.
--
Retirement is great! Especially in the Caribbean… :-)
Raymond
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...
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...
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
Hence your modified table: https://www.cjoint.com/?ivrEkr6UZ6
Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
Raymond
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
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
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
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