Excel rounds off the row height and column width settings to two decimal places.
Is there a way to increase this to three or four places?
Jim
BTY. I am running Office professional plus 2019 not 2007 as shown on my post.
Excel rounds off the row height and column width settings to two decimal places.
Is there a way to increase this to three or four places?
Jim
BTY. I am running Office professional plus 2019 not 2007 as shown on my post.
Last edited by jimbir; 12-30-2023 at 06:56 PM. Reason: Correction
You can calculate the width and height yourself.
The width and height can't be anything other than an integer number of pixels.
Excel charges me 3/4 per pixel for the height and for the width Exel charges me 1/12 per pixel for the first 12 pixels and then 1/7 per pixel.
Example: If the column on the screen is 50 pixels wide, Excel indicates a width of 12*1/12 + (50-12)*1/7 = 6 3/7 is 6.4286 (rounded to 4 decimal places) is 6.43 (rounded to 2 decimal places)
However, I don't know if these numbers depend on local settings and/or font settings.
In Excel, you can't set the height and width more accurately. Each height is rounded to a multiple of 3/4 and any width greater than 1 is rounded to a multiple of 1/7 (and then to 2 decimal places) and any width less than 1 is rounded to a multiple of 1/12 (and then to 2 decimal places).
So I don't think it makes sense to round the height or width to 3 or 4 decimal places.
Last edited by HansDouwe; 12-30-2023 at 10:22 PM.
I think you see no difference between 6.4286 and 6.43
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Thanks for the Reply. The reason for my question is explained below.
I have set a column width to .375. When I right click on it and select column width in the drop-down menu, I see .37. Id really like to see .375. That is why I would like to be able to set the decimal places to something more than 2.
Now, when I switch from the Page layout view to normal, I see the number 3.6. What does that indicate? Pixels?
I think it might be in points, which is an old printing measure for 1/12th of an inch.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks