Replacing Characters

Jenn · Oct 26, 2004

I have a column (lets say column A) that has values like the following:
15467
12099
2099
1312
What I would like to do is make column B replace the last 2 characters with
zeros so that column b looks like the following:
15400
12000
2000
1300

Can anyone help? Thanks in advance!

Frank Kabel · Oct 26, 2004

Hi
in B1 place
=ROUNDDOWN(A1,-2)
and copy this down for all rows

Jenn · Oct 26, 2004

Thanks perfect!

Frank Kabel said:
Hi
in B1 place
=ROUNDDOWN(A1,-2)
and copy this down for all rows

Replacing Characters

Jenn

Frank Kabel

Jenn