[Tom Ogilvy]

change
X + 3.5

to

format(X + 3.5,"#.00")

Regards,
Tom Ogilvy

Memnoch <randmtask at optushome . com . au wrote in message
u...
Im trying to work out how to pass values to an email with two decimal
places.

ie:

xlRg.Offset(2, 12).Formula = "=HYPERLINK(" & Chr(34) & "mailto:" & Email &
"?subject=" & X + 3.5 & "&Body=" & Msg & Chr(34) & ", " & Chr(34) & "Send
Email" & Chr(34) & ")"

For the instances where (X+3.5) is, say, 40.51 there is no problem, as it
will say 40.51 in the email
If (X+3.5) is 41.50 there is a problem, as it will say 41.5 in the email,
not 41.50

cheers,

Memnoch

[Memnoch]

"Tom Ogilvy" wrote in message
...
change
X + 3.5

to

format(X + 3.5,"#.00")

Regards,
Tom Ogilvy


Thanks mate, that was a big help!

Memnoch