Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Column width Units

  1. #1
    Guest

    Default

    I have foolishly created a design were my column wdths are in MM, i need to input these precise measurements into my spreadsheet, however i can't work out what measurement the columns are measure in, and how i can convert it into mm, please help, probably very easy but very frustrating!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi there
    According to Help, the display column width is the average number of digits 0 through 9 of the standard font that fits in the cell.
    This probably isn't very helpful, but presumably your project is eventually to produce this on a printed page of some sort. If so, print out a few pages of grid pattern and measure the column / row widths and adjust them till they match the scale of your drawing.
    Hope this is of some use
    Derek

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'Day Derek,

    I made a 118mmx118mm black square in paintbrush, saved it as a bitmap and then stuck it in excel. Then I increased the column width which it sat on so it straddled the image then looked at the column width which was 53.43 units

    so 53.43 excel column width units = 118 mm

    or 259/572

    maybe you can adjust you measurements by that same proportion and in theory it should all work out

    Hope this helps, albeit relatively negatively

    Chris


    [ This Message was edited by: Chris Davison on 2002-02-21 12:14 ]

    [ This Message was edited by: Chris Davison on 2002-02-21 12:16 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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