+ Reply to Thread
Results 1 to 2 of 2

Setting Column width & Row height in excel 2003

  1. #1
    prasadsn1976
    Guest

    Setting Column width & Row height in excel 2003

    Hi,

    In excel 2003,
    I need to set the column width as "8.23" but it's rounding off to "8.29"
    The same issue i have while setting the row height also

    Please let me know your valuable suggestions to set the needed width or height and overriding the auto round off.

    Regards,
    S.N.Prasad

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Setting Column width & Row height in excel 2003

    It is always a good idea to search the forum (or even Google) for a solution before posting. In your case the same question was answered last year.

    http://www.excelforum.com/excel-gene...-rounding.html

    To summarize, the measurement is a number of character-widths for the current font, but it uses an integer number of pixels. 8.29 gives the nearest integer number of pixels to 8.23 for the font you're using.

    Here is a more detailed explanation from Microsoft


    http://support.microsoft.com/kb/214123
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1