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 |
Need help with decimal places
"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 |
All times are GMT +1. The time now is 10:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com