Try this formula
=--LEFT(A1,LEN(A1)-2)
--
Regards Ron de Bruin
http://www.rondebruin.nl
"geza" wrote in message ...
Heloo everyone,
I am looking for a simple formula: in a column of numerical values such as
50405, how would i get rid of the last two numbers, i.e from 50405 to 504.
Thank you,
Geza