| 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" |
| 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 | |||
Threaded Mode
