Can't calculate after decimal point.

[bralew]

Hi all, does anyone advise how I can multiply a TextBox contents after the decimal point?

So essentially I need -

Please Login or Register  to view this content.

Many Thanks

[frabulator]

I dont think I quite understand. Please explain 'after the decimal point'. Your code above should work even with decimal points.

Please Login or Register  to view this content.

[bralew]

I'd like to omit the first figure so , TextBox3.Value * 2.369 would be:

TextBox3.Value * .369

[frabulator]

I'd like to omit the first figure so , TextBox3.Value * 2.369 would be:

TextBox3.Value * .369

Would something like the following be what you are looking for?
The first is a straight multiplication.
The second does a search for the decimal place and omit everything in front of it including the decimal.
The third is the same as the second except it includes the decimal.

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

?

[xlnitwit]

Hi,

You might use

Please Login or Register  to view this content.

[bralew]

Thanks frabulator, I'm looking for something a little easier to maintain, but thank you.

Hi Jindon, the code doesn't come up with the required figure?

[frabulator]

xlnitwit's code is actually a condensed version of mine. It should be a lot easier to maintain

[LeoTaxi]

Depending on your decimal seperator 1 of this 2 can do

Please Login or Register  to view this content.

Kind regards
Leo

[bralew]

Thanks lads, ;-)

[LeoTaxi]

or

Please Login or Register  to view this content.

cheers
Leo