How many column units and row units to an inch in Excel?

Column width is the number of characters that will fit in the cell, using a fixed-width font (such as Lucida Console, Courier, FixedSys, Letter Gothic, Pica etc).
I've heard that 1 inch = 13 units on one site, but only 10 units on another, so perhaps someone can clarify.
I've also seen a column width unit described as equal to the width of the number 2 in 12 point Arial font (which is great cos Arial isn't a fixed-width font!).

Row height is measured in Points (PostScript).
1 inches = 72 points, but Excel rounds off to a quarter of a point.

Take a look here:
http://support.microsoft.com/default...ticle%3D214394 Answered Dec, 22 2010

Run this macro:

Private Sub CommandButton1_Click()
Set myRng = Range("A1:A3")
For Each cl In myRng
If (Left(cl.Value, 1) = "." Or (Left(cl.Value, 1) >= 0 And Left(cl.Value, 1) <= 9)) Then
For i = 1 To Len(cl.Value)
If Not (Mid(cl.Value, i, 1) = "." Or (Mid(cl.Value, i, 1) >= 0 And Mid(cl.Value, i, 1) <= 9)) Then
cl.Value = Left(cl.Value, i - 1)
End If
Next i
Else
For i = 1 To Len(cl.Value)
If Not (Mid(cl.Value, i, 1) = "." Or (Mid(cl.Value, i, 1) >= 0 And Mid(cl.Value, i, 1) <= 9)) Then
cl.Value = Right(cl.Value, i)
End If
Next i
End If
Next
End Sub
read more:http://Run this macro: Private Sub CommandButton1_Click() Set myRng = Range("A1:A3") For Each cl In myRng If (Left(cl.Value, 1) = "." Or (Left(cl.Value, 1) >= 0 And Left(cl.Value, 1) <= 9)) Then For i = 1 To Len(cl.Value) If Not (Mid(cl.Value, i, 1) = "." Or (Mid(cl.Value, i, 1) >= 0 And Mid(cl.Value, i, 1) <= 9)) Then cl.Value = Left(cl.Value, i - 1) End If Next i Else For i = 1 To Len(cl.Value) If Not (Mid(cl.Value, i, 1) = "." Or (Mid(cl.Value, i, 1) >= 0 And Mid(cl.Value, i, 1) <= 9)) Then cl.Value = Right(cl.Value, i) End If Next i End If Next End Sub Answered Apr, 19 2011

here is a detailed solution,go and look it carefully
http://excel.tips.net/Pages/T002630_Converting_Units.html Answered Dec, 27 2010

I am assuming that - - You are making a graph. You have a worksheet with the data on it.

One column of the data should be "Year" and you should type in the years - - 1880, 1890 . . . 1990 (It would probably be best if this were column "A"

Does this help?

Sincerely,
Deb

*******************
More help . . .

Ah. I think I have it . . .

In my example I have "Year" in column A and "Population" in column B

High-light the data that you want to chart.
Click on the "Chart Wizard" icon
Choose "Column" and click "Next"
At the "Chart Source Data" screen -
Click on the "Series" tab
I am going to "Remove" the "Year" from the series
For "Category X axis labels" - -
I click on the icon next to the field
Then I high-light column A (just click on the A and it will high-light the whole column)
Press "Enter"
Click on "Finish"

There . . . did that do it . . . ???

Answered Nov, 10 2010