I am transforming excel tables into the word tables and I was wondering if Excel cell width = 20 what would that be in the word table cell width
Thanks in advance
Printable View
I am transforming excel tables into the word tables and I was wondering if Excel cell width = 20 what would that be in the word table cell width
Thanks in advance
Excel uses characters, points, and pixels as units of measurement. Word uses Inches.
Code:Points Pixels Inches
18 24 0.25
36 48 0.5
72 96 1.0
108 144 1.5
144 192 2.0
In word you can use the InchesToPoints and PointsToInches functions to do any conversions.
VB Code:
xxx = InchesToPoints (0.25) xxx = PointsToInches (20)
OK, but what I have is in Excel the cell width is 20 which is roughly an equivalent of combining with of two default cells. According to your previous post, it would mean that to represent this in Word i would have to set the cell width to .25 and to me that does not represent that wide column that I have in Excel. Or am I wrong?
8.43 is characters and it equates to 64 pixels per column in Excel for default. So a double width default width column will
be 16.86 characters or 128 pixels or 96 points or 1.25" ?
This is straight from the help file.
thanks, i guess i missed it. in any case i had to re-calculate the size of the cells based on the total print area of the page, keeping in mind the layouts and different paper sizes and such.
and i am happy to say that this is solved
i16978
Cool! Gladto help. I didnt realize that they used different measurement units between Office apps until this thread. :thumb: