Thread: Carriage Return and Splitting Lines to Lotus Notes Msg through VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
skiloa skiloa is offline
external usenet poster
  
Posts: 8
Default Carriage Return and Splitting Lines to Lotus Notes Msg through VBA
Thanks - that worked!

Any idea on how to get percnet format come across as such. In Excel I
have 2.8912% and it's coming across on the email as .028912...

In addition, is it possible to get this formatting done in a
concatenate formula? e.g.,

="The rates below reference"&A2&"."

Where A2 = 4/12/05, this resolves as "The rates below reference 38505"
(or whatever the Excel date is) instead of "The rates below reference
4/12/05"

Reply With QuoteReply With Quote