How to multiply column values without creating another column?

[#1]

I have a column with decimal values that needs to be multiplied by 100. Is there other ways to do it without creating another column with formula? Is it possible to do it on the same column?

[#2 · Accepted solution]

The easiest way to do this is to write a little script.  If the name of your column that you want to change is called "The Column", the following script will 

For Each Row( :The Column = :The Column * 100 );

[#3]

I tried re-creating this with a For Loop, but doesn't work.

dtcols = {"Score1", "Score2"};

For( i = 1, i <= N items (dtcols), i++,
	For Each Row( dtcols[i] = dtcols[i] * 100 );
);

[#4]

You need to tell JMP the element from the list is a column.

dtcols = {"Score1", "Score2"};

For( i = 1, i <= N Items( dtcols ), i++,
	For Each Row( As Column( dtcols[i] ) = As Column( dtcols[i] ) * 100 )
);

BTW, a simpler form to use is with a For Each() function

For Each( {col}, dtcols,
	For Each Row( As Column( col ) = As Column( col ) * 100 )
);

[#5]

Thank you! I'm learning a lot ^^