dattagal
05-17-2007, 10:23 AM
Hi guys
:banghead:
Would appreciate some help with currency formats in a concatenated string.
I have a string that include references to cells in another worksheet. The string works just fine but cell reference parts are supposed to be dollar amounts...
Sheets("FormEnglish").Cells(73, 1) = "If you are enrolling for [product] in excess of the GI amount of" & " " & Sheets("Questions").Cells(43, 4) & " " & "or if your spouse is enrolling for coverage in excess of 50% of the amount that you enroll for or" & " " & Sheets("Questions").Cells(43, 5) & " " & ", you must complete and submit an EOI. The form is available from your employer/benefits administrator, or is available online at...
Instead, it comes out like this...
If you are enrolling for [product] in excess of the GI amount of 500000 or if your spouse is enrolling for coverage in excess of 50% of the amount that you enroll for or 150000 , you must complete an and submit and Evidence of Insurability form. The form is available from your employer/benefits administrator, or is available online at...
Is there some way I can format the amounts to be currency?
Any assistance will be greatly appreciated.
Cindy
:banghead:
Would appreciate some help with currency formats in a concatenated string.
I have a string that include references to cells in another worksheet. The string works just fine but cell reference parts are supposed to be dollar amounts...
Sheets("FormEnglish").Cells(73, 1) = "If you are enrolling for [product] in excess of the GI amount of" & " " & Sheets("Questions").Cells(43, 4) & " " & "or if your spouse is enrolling for coverage in excess of 50% of the amount that you enroll for or" & " " & Sheets("Questions").Cells(43, 5) & " " & ", you must complete and submit an EOI. The form is available from your employer/benefits administrator, or is available online at...
Instead, it comes out like this...
If you are enrolling for [product] in excess of the GI amount of 500000 or if your spouse is enrolling for coverage in excess of 50% of the amount that you enroll for or 150000 , you must complete an and submit and Evidence of Insurability form. The form is available from your employer/benefits administrator, or is available online at...
Is there some way I can format the amounts to be currency?
Any assistance will be greatly appreciated.
Cindy