Board index MS WORD

How can I stop Merged nos. from excel having 6-7 nos after decimal

How can I stop Merged nos. from excel having 6-7 nos after decimal

Post by d2FyYmFyY » Fri, 16 May 2008 00:24:00


I merged nos from an excel spreadsheet into a chart in a memo done in word.
I formatted the nos in excel to 0 or 2 decimal places but when they merge
into excel I get 6-7 numbers after decimal and have to go in on each memo and
delete the extra numbers. How can I get these extra decimal places not to
come in when merging?
 
 
 
Top

How can I stop Merged nos. from excel having 6-7 nos after decimal

Post by Doug Robbi » Fri, 16 May 2008 04:23:49

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.yqcomputer.com/


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 
 
 
Top

1. Doc. Page Nos. vs Sec. Page Nos.

2. how to find nos. of each day in certain nos. of days?

3. How to find serial nos (unique H/W nos) of peripherials , any devices in a PC

4. Insert numbering field in merged Word document (invoice nos)?

5. with random No's calc how can I stop two different columns pre

6. with random No's calc how can I stop two different columns predic.

7. I want print excel sheet with nos in the back ground, as shown in.

8. How do I get excel to generate Random nos for my data?

9. My I's are coming up i's. (lower case)

10. Count Nos in string

11. Numbered scale spaced by interval defined by nos in column

12. Create a Validation rule for IBAN Account nos in a form field

13. add yes/no's in access database

14. selecting nos from table

15. Formats for Telephone Nos

All times are UTC
Board index