By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

numeric formatting

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Something like

Result = Format(Source * 100 \ 1, "#00000") ?

Pavel

lintcoop wrote:

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

Nov 12 '05 #2

P: n/a

"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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.