Money value to string(s)

R

Rob

Hi,
I want to translate a money value to two strings.
For example a field contains $234.45 then this should be
split up into two strings: "234" and "45".
I'm sure that there is a very simple solution for this,
but I cannot think of any.

Rob
 
K

Ken Snell

Here's one way:

DollarAmount = Int(MoneyValue)
CentsAmount = MoneyValue - Int(MoneyValue)
 
G

Guest

OK,

But if I have a value like 12.50
then the centsamount will be 0.5. I would like to
have "50" and if the value is 12.00 then the centsvalue
is "00".

/Rob
 
Top