format a column

[xcao]

I have a simple question to ask, I have a column in Excel is number like 142000, I want to format the whole column numbers without the two ending 0s,

change 142000 to 1420, how can I do that?

Thanks

[David Billigmeier]

Enter 100 in an empty cell and copy it. Then, select your range of numbers
you want to change, Right Click and go to Paste Special, and select Divide.

--
Regards,
Dave


"xcao" wrote:

>
> I have a simple question to ask, I have a column in Excel is number like
> 142000, I want to format the whole column numbers without the two ending
> 0s,
>
> change 142000 to 1420, how can I do that?
>
> Thanks
>
>
> --
> xcao
> ------------------------------------------------------------------------
> xcao's Profile: http://www.excelforum.com/member.php...o&userid=14538
> View this thread: http://www.excelforum.com/showthread...hreadid=471821
>
>

[xcao]

Thank you, it's helpful