Number format 
Author Message
 Number format

The number formats just cut off the number after the given number
of decimals points. In order to ROUND the number, you need to use
VBA code (linked to an input field's EXIT macro) to calculate the
result you want, and insert it into the result field (then the
form field can no longer be of type "Calculation", it must be a
plain text field, disabled for user input).

Quote:
> Could anyone help me ? The problem is following : I use forms
> in my Word97 document. The number format for each form field
> is #,##0.00 . Is it possible to get in this field the CORRECT
> result of calculations ? For example the real result is 8.678
> but Word pasts in the field only 8.67 ! How to avoid this case ?
> (Actually I need ONLY two numbers after the dot )
> How to achieve the right result (8.68) ?

Cindy Meister
INTER-Solutions, Switzerland
http://www.*-*-*.com/
http://www.*-*-*.com/

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)



Sun, 23 Feb 2003 22:30:09 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to convert number format to date format

2. "Accounting" Number Format

3. Access 97 and signed number formats

4. Number format and regional settings

5. microsoft outlook phone number formatting

6. Number format in Access 2000

7. Number Format in UserFrom Lables and Text Boxes

8. Problems with number format

9. Change Phone Number Format

10. Number formatting

11. Telephone number formatting

12. Simple quesiton on Number Format .. ^_^

 

 
Powered by phpBB® Forum Software