Converting characters to points

[3rRiXzN0O]

Does anyone know the formula to convert characters (the unit of measurement for column width) to points (the unit of measurement for row height)? There doesn't appear to be a direct linear relationship.

 

[Peter_SSs]

Does this help?
http://processtrends.com/pg_charts_cell_size.htm

 

[3rRiXzN0O]

It would, but it doesn't appear to be accurate. A pixel is 0.75 points, so it's easy to convert from pixels to points, but I still can't get from characters to pixels or points. That site gives the formula Characters = (Pixels - 5) / 5, but for example, the default width is 8.43 characters or 64 pixels. (64 - 5) / 5 does not equal 8.43.

Characters is also not the 64 / 8.43 = 7.6 pixels that would seem logical, for 3.29 characters = 28 pixels.

 

[Juan Pablo González]

Maybe this then?

http://www.pcreview.co.uk/forums/column-width-pixels-t950900.html

 

[3rRiXzN0O]

I think I found it. It appears to be, obscurely, Characters = (Pixels - 5) / 7.

http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/7f461fac-5b41-4049-b3c9-bb3c2ab8cbbc/

Thanks

 

[shg]

The column width is nominally the number of 0's you can put in a cell that uses the font name, font style, and font size for style Normal, so it will vary.