A round about way would be to have it multiply by .01 and then either
convert it to a integer or just have it not show decimals

"JcR" wrote in message
...
I want to be able to:

enter a 5 digit number into in cell a1

have the first 3 digits appear in cell a2

Thanks