Trimming a larg number

[Reggie]

Hello everyone,

I have a list of part numbers. The warehouse adds two zero's to the end of these part numbers. I need to trim the last two zero's for my DB. I am not having any luck creating a script to do this function.

Can anyone give me a script that can cut off the last two digits of the number?

Thank you very much for the help.

Reggie

[Fitch]

Left( NumToText(PartNumber), Length(NumToText(PartNumber) - 2) )

...or maybe you could just divide by 100.