Thread: Resolving percent and date formats as such in concatenate function and emails
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Yandl[_3_] Steve Yandl[_3_] is offline
external usenet poster
  
Posts: 117
Default Resolving percent and date formats as such in concatenate function and emails
Try
="The rates below reference "&TEXT(A2,"#.0000%")


Steve



"skiloa" wrote in message
ups.com...
Any ideas 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