Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Column/Row Width & Height (O2K)

    I've searched through all of the previous posts, and can't seem to find anything that references this issue. When I enter (by either right-clicking or selecting Format) a number Excel seems to change it, and I can't figure out how to make it stop.

    For instance- I need a row height to be 22.80 points high, yet when I enter this number, hit enter, then check it again, it ends up being 23.00

    I've checked my Special Ed. on O2K, checked MS Knowledge Base, and can't find a solution. Can anyone please tell me what's going on and how I can change it?

    This is for a test..I've asked my instructor and he can't figure out the problem either. I've gone as far as formatting my pc (needed it anyway), but I'm now at my wits end...

    Any help would be greatly appreciated-

    Kiddo

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    That is because the rowheight is always a whole number of pixels, whereas the height in points can be any decimal.

    So the point number you enter is rounded in such a way that the number of pixels is an integer.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    ok, thanks. Does this mean that regardless of what I do, this is going to round up or down? At one point, it was going to 22.5, but I don't remember what I did.

    Thanks again-

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    They seem to round to teh nearest .25 point (1 point 1/72 inches)

    Andrew C

  5. #5
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    This site is great! My problem is that I forget it's here!! Thanks for your replies. I have only two more questions. (unless your response prompts another <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

    Is there any way to prevent the rounding? I guess, make it come up exactly as I type it in. If not, does anyone know why an Office Instructor would ask it if it isn't possible??

    Thanks again for your help <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Kiddo

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    I think th eprounding is fixed unfortunately - maybe somebody else knows differently.

    Your Office instructor may not be fully aware of the limitation or did not take it into account. Perhaps if the instructor has a method, you can share it with us if he/she reveals it.

    Don't quote me on this, but sometimes instructors do not know everything.

    Andrew C

  7. #7
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    It may be that it worked out on his machine! :-)

    I tried your 22.8 on mine and it worked OK but 22.9 rounded. Presumably it has to do with screen resolution but I have not tested it.

  8. #8
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    That's definitely interesting. I tried every combo of screen size/resolution I could think of, and it still came up at 23. Errors are bad enough, but it drives me crazy for something like this to happen and not be able to figure out why.


    Thanks for the input though-

    Kiddo

  9. #9
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    Just tried it with other screen resolutions and 22.8 still ok!

    FWIW I am using W2K Office 2K

  10. #10
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    Well, it's probably because I'm using this <img src=/w3timages/censored.gif alt=censored border=0> Windows ME. May I ask what screen resolution you are currently using (assuming you tried it and was successful)? Anyone have any Valium you could email me <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15> (JK)

  11. #11
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    1024 x 768 by memory I will check in the morning.
    at home w98 and Excel 2 K rounds up

  12. #12
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    It may also be useful to know the font you are using and the font size selected.

    Can you set a row height to 11.85 ?

    Andrew C

  13. #13
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    Are there some kind of settings I'm missing here? Is there an 'option' or configuration that has made this thing goof up? I just formatted and reinstalled everything because of this.

    My specs are:

    WinME, O2K Premium, 1024x768, 32 bit color.. I've tried 16 as well.

    <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

    Thanks-

    Kiddo

  14. #14
    Lounger
    Join Date
    Apr 2001
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    Default font, at least I presume so. Arial 10, I just tried to set the row height to 11.85 and ended up with 11.75...

    GRRRRR

  15. #15
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Column/Row Width & Height (O2K)

    11.85 rounds to 11.9
    font Arial 10 and changing it seems to make no difference


    Peter

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •