| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with data from cells in merge fields
Overview: I have merge document set up to merge with my spreadsheet. The cells I want it to merge with have been formatted as a percentage with 3 decimal places. When I merge the cells into my document, however, it is giving me a number like this 7.748000558954E-2 instead of 7.75%. What am I doing wrong? Thanks Cary D -- caryd ------------------------------------------------------------------------ caryd's Profile: http://www.excelforum.com/member.php...o&userid=34433 View this thread: http://www.excelforum.com/showthread...hreadid=543485 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem with data from cells in merge fields
Excel might be FORMATTED to show 3dp, but it still contains 15dp - try
using formatting codes in your merge fields to get the format correct |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
| External data Macro Problem Excel 97 | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| How do I merge individual data now in multiple cells, in to one b. | Excel Worksheet Functions | |||
Linear Mode
