Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate & custom formats | Excel Discussion (Misc queries) | |||
How to get different text formats in a concatenate function | Excel Discussion (Misc queries) | |||
Percent Formats | Excel Discussion (Misc queries) | |||
How do I use the concatenate function to add a date into a sentenc | Excel Worksheet Functions | |||
Preserving text formats with Concatenate function | Excel Programming |