Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
No macros // i've even gone to the extreme of using Format on the toolbar
using Clear/Format on the cells and re-formatiing the cells/ I'll try reloading my Office program --- maybe it got corrupted. ? Any suggestions are helpful. Thanks. "Martins" wrote: I have calculated cells formatted for Currency w/ 2 decimal places// when print they have 15 decimal places // I've tried standard formatting Number & Accounting and they also print 15 decimal places when formatted for 2 decimal places // how can this be corrected so when cell formatted for 2 decimal places it will print 2 decimal places ? |
#2
![]() |
|||
|
|||
![]()
You are printing through excel, right?
You're not using mail merge and MSWord? Martins wrote: No macros // i've even gone to the extreme of using Format on the toolbar using Clear/Format on the cells and re-formatiing the cells/ I'll try reloading my Office program --- maybe it got corrupted. ? Any suggestions are helpful. Thanks. "Martins" wrote: I have calculated cells formatted for Currency w/ 2 decimal places// when print they have 15 decimal places // I've tried standard formatting Number & Accounting and they also print 15 decimal places when formatted for 2 decimal places // how can this be corrected so when cell formatted for 2 decimal places it will print 2 decimal places ? -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
Dave, we are merging to MS Word// is this a known issue ?
"Dave Peterson" wrote: You are printing through excel, right? You're not using mail merge and MSWord? Martins wrote: No macros // i've even gone to the extreme of using Format on the toolbar using Clear/Format on the cells and re-formatiing the cells/ I'll try reloading my Office program --- maybe it got corrupted. ? Any suggestions are helpful. Thanks. "Martins" wrote: I have calculated cells formatted for Currency w/ 2 decimal places// when print they have 15 decimal places // I've tried standard formatting Number & Accounting and they also print 15 decimal places when formatted for 2 decimal places // how can this be corrected so when cell formatted for 2 decimal places it will print 2 decimal places ? -- Dave Peterson |
#4
![]() |
|||
|
|||
![]()
Yep.
Debra Dalgleish posted this to a similar question: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. Martins wrote: Dave, we are merging to MS Word// is this a known issue ? "Dave Peterson" wrote: You are printing through excel, right? You're not using mail merge and MSWord? Martins wrote: No macros // i've even gone to the extreme of using Format on the toolbar using Clear/Format on the cells and re-formatiing the cells/ I'll try reloading my Office program --- maybe it got corrupted. ? Any suggestions are helpful. Thanks. "Martins" wrote: I have calculated cells formatted for Currency w/ 2 decimal places// when print they have 15 decimal places // I've tried standard formatting Number & Accounting and they also print 15 decimal places when formatted for 2 decimal places // how can this be corrected so when cell formatted for 2 decimal places it will print 2 decimal places ? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |