Column width Units

Feb 21st, 2002, 05:10 AM

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!

Derek · Feb 21st, 2002, 05:47 AM

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

Chris Davison · Feb 21st, 2002, 01:10 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 05:10 AM	#1
Guest Posts: n/a	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!

Feb 21st, 2002, 05:47 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Feb 21st, 2002, 01:10 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ]