Resolving percent and date formats as such in concatenate function and emails
 

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"

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"

Resolving percent and date formats as such in concatenate function and emails
 

Sorry, I should have read your question all the way through.
For the percent, try
=TEXT(A2,"#.0000%")
and for the date in the concatenate formula, try
="The rates below reference "&TEXT(A2,"m/d/yy")

Steve


"Steve Yandl" wrote in message
...
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"

Resolving percent and date formats as such in concatenate function and emails
 

I ended up figuring out how to resolve the date after your first
example - thanks.