How can I make my row height exactly 21.4?

[Guest]

Each time I try to make my row height an exact size it rounds to the nearest
..25. I am using Microsoft Office XP and I have all of the latest updates.

 

[Guest]

Each .25 is equal to 1 pixel on the display. And the display cannot go less
than 1 pixel. So you won't be able to get a row height other than in .25
increments.

 

[Gord Dibben]

Monty

You cannot change this default behaviour.

Why do you need 21.4 points?

Perhaps there is something else can be done to approximate if we knew why.

Like set to millimeters or inches via VBA although I doubt you'll get closer
than 1/72 of an inch which is the difference between 21.4 and 21.5

Not seen by the naked or clothes eye, I would submit.

Gord Dibben Excel MVP

 

[Gord Dibben]

I think that should read "1/720" of an inch.

Gord