plz help me

[Bormans Erwin]

Hello, i must teach some lessons of excel and i get some questions that i
don't know the answer, so maybe you can help me.

1) When you select a row or a kolom and want to change the height or width,
with me the standard value's are 12,75 and 8,43 but i don't know what it is.
Is it milimeters, centimeters (but that's not possible), pixels, ...

2) When you enter 3 numerical value's, leave then one row open and then you
put there a function to count them up, it works just fine. But when you
enter a fourth numerical value it automatic recalculated and takes the fouth
value with: for example
A1 100
A2 200
A3 300
A4
A5 = SOM(A1:A3)

Is this an option or is this always like that, i use MS Excel 2000 SP-3. And
i think that excel has no right to do that so i want it to be undone. Is
this possible?

I'm sorry for my bad englisch, but i still hope you understand me!

Kind regards Erwin

Erwin Bormans
Docent Aron
www.aron.be
(e-mail address removed)

 

[Jan Karel Pieterse]

Hi,

1) When you select a row or a kolom and want to change the height or width,
with me the standard value's are 12,75 and 8,43 but i don't know what it is.
Is it milimeters, centimeters (but that's not possible),

pixels, ...

From Excel's VBA Help:

RowHeight Property


Returns the height of all the rows in the range specified,
measured in points.

ColumnWidth Property


Returns or sets the width of all columns in the specified
range. Read/write Variant.

Remarks

One unit of column width is equal to the width of one
character in the Normal style. For proportional fonts, the
width of the character 0 (zero) is used.

2) When you enter 3 numerical value's, leave then one row open and then you
put there a function to count them up, it works just fine. But when you
enter a fourth numerical value it automatic recalculated

and takes the fouth value with: for example

Tools, Options, edit tab, "Extend List formats and
formulas"

Regards,

Jan Karel Pieterse
Excel TA/MVP

 

[Bormans Erwin]

Thanks for the quick reply!!!

The second problem is solved know, but the first problem i not really
understand. So it means that when i have a column width of 8,43 that it is
8,43 zero's width?

Thanks a lot!

Kind regards Erwin

 

[Jan Karel Pieterse]

Hi Erwin,

The second problem is solved know, but the first problem i not really
understand. So it means that when i have a column width of 8,43 that it is
8,43 zero's width?

Something like that: 8,43 zero's when formatted as the standard font.

Regards,

Jan Karel Pieterse
Excel TA/MVP