Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get the rounded values from excel to a word document.
When I imported an excell spreadsheet data into a word document, the vales in
the currency field were not rounded to two places even though the cells were formatted to two places. This is using office 2003. I had used this in an older version and it worked fine. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get the rounded values from excel to a word document.
Rather format use ROUND(whatever,2)
Formatting does not change the stored value only the displayed value best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "New York Grange" <New York wrote in message ... When I imported an excell spreadsheet data into a word document, the vales in the currency field were not rounded to two places even though the cells were formatted to two places. This is using office 2003. I had used this in an older version and it worked fine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting charts to Word from Excel as picture | Charts and Charting in Excel | |||
Converting a Word Document to excel | Excel Discussion (Misc queries) | |||
How to change a excel document into a word document? | Excel Discussion (Misc queries) | |||
Word document embedded in Excel 2003 won't wrap | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) |