Need help with decimal places
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
|