Replacing Characters

[Guest]

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]

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

 

[Guest]

Thanks perfect!

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