"lintcoop" <lc*****@hancocklumber.com> wrote in message

news:2a**************************@posting.google.c om...

I am importing large numeric data sets from different sources. The

decimals are placed as follows:

100.00 = 100

100.10 = 100.1

100.11 = 100.11

I need to eliminate the decimal point without rounding. The format I

need for the 3 examples would be:

10000

10010

10011

Any suggestions would be appreciated.

Thanks

Multiply by 100? ;)}

Nick