Exel in cm ?

zzino · Feb 18th 2003

Hi,

does anybody known how to put the height and width value in cm ?

thx in advance
zz.

Deathlace · Feb 18th 2003

What a type of format are you using to place in the hight?

Are you going to be typing in the amount of feet, inches, or feet and inches.

From there we can write the formula to convert inches/feet to cm.

Can you attach the document in question.

blue · Feb 18th 2003

Are you possibly talking about the height and width of rows and columns?

Denis · Feb 18th 2003

Quote

Originally posted by blue
Are you possibly talking about the height and width of rows and columns?

Assuming that this is the case, one point = 0.035 centimeters. (taken from VBA help for "CentimetersToPoints") Therefore:

Row Height * 0.035 = Row Height in cm.

zzino · Feb 21st 2003

thx,

sorry for the delay, but i was a few days out of office

as i can understand, what i need is a vba script who calculate this for hight and width ?

Participate now!