| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Number Outlook Merge
I have an Outlook merge email that will be pulling numbers from an excel
spreadsheet. The numbers are displayed in Excel with one decimal point (53.2%), but the actual number has about 10 points behind the decimal (53.2158691235). When a merge takes place, then all 10 decimal points carry over to the merged email. I know in a Word merge, you can format the number after the merge, but with an email, I am not aware of a process to format this number down before the email goes out. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Number Outlook Merge
=TEXT(A1,"0.0%")
-- David Biddulph "SJC" wrote in message ... I have an Outlook merge email that will be pulling numbers from an excel spreadsheet. The numbers are displayed in Excel with one decimal point (53.2%), but the actual number has about 10 points behind the decimal (53.2158691235). When a merge takes place, then all 10 decimal points carry over to the merged email. I know in a Word merge, you can format the number after the merge, but with an email, I am not aware of a process to format this number down before the email goes out. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any way to merge an excel address list with outlook make. | Excel Discussion (Misc queries) | |||
| Format Cell using letter & number to use in mail merge | Excel Worksheet Functions | |||
| Mail merge, Outlook | Excel Discussion (Misc queries) | |||
| Excel/Outlook Mail Merge??? | Excel Discussion (Misc queries) | |||
| help with excell to outlook for mail merge | Excel Worksheet Functions | |||
Linear Mode
