what is the r value of the following data to three decimal places apex

Delight Note: This article is written for users of the following Microsoft Give-and-take versions: 2007 and 2010. If you are using an earlier version (Word 2003 or before), this tip may non work for you. For a version of this tip written specifically for before versions of Discussion, click here: Setting Table Values to Three Decimal Places.

Setting Tabular array Values to Three Decimal Places

Jacob has a tabular array containing numeric values pulled from some other program. I of the columns has numbers that might exist iii.256000 in i jail cell and 23.200000 in another. He always needs to go through all of these numbers and make them only 3 digits to the right of the decimal indicate. Jacob wonders if there is a style to automatically step through all the values using a macro and make certain they have only three digits to the right of the decimal indicate.

This could certainly be done with a macro, only that might not be the best way to do it. The first potential solution is to wait at how you are getting your original data. If it is possible, you might desire to alter the program that generates the data so that it uses only 3 decimal places. Or, alter information technology so that the data ends upwards in an Excel worksheet that you tin and then embed within your Word document.

If that doesn't work, you might be able to modify the program so that information technology doesn't insert numeric values, only inserts fields that brandish the numeric values. This may sound confusing, but y'all can use fields to display only a specific number of digits of a value. This type of field formatting has been discussed in other WordTips.

If you cannot alter the way that the original program generates the information that ends up in the table (and nearly of the time people can't change it), then y'all can employ Observe and Replace to limit your values to three decimal places. Follow these steps:

1. If you desire to limit your supersede performance to a specific portion of your certificate (such as a table or a column inside a table), select that portion of the document.
2. Press Ctrl+H to display the Supplant tab of the Find and Supersede dialog box.
3. If the More button is visible, click information technology and so that y'all end up with an expanded dialog box.
4. Brand sure the Utilize Wildcards check box is selected.
5. In the Discover What box, enter the following: ([0-nine].[0-9]{3})[0-nine]{one,}
6. In the Replace With box, enter the following: \i
7. Click Replace All.

What these steps practise is to look for any digit (0 through ix) followed past a decimal point and three digits. This is a "group" (one digit, decimal point, three digits) that must be immediately followed by at least ane digit, and maybe more. When this sequence is found, information technology is replaced past the first grouping (one digit, decimal point, three digits). The result is that everything beyond the third digit after the decimal point is chopped off.

This Discover and Replace approach is quick and easy, and it doesn't involve the utilise of macros. It also doesn't circular the information that is left in your document. If yous need to accept the values rounded to 3 digits instead of cut off at iii digits, then you are best to go back to the "see if you can change the originating program" arroyo discussed at the beginning of this tip.

If you would like to know how to use the macros described on this page (or on any other folio on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for toll-effective Microsoft Word grooming. (Microsoft Word is the nigh popular word processing software in the world.) This tip (11467) applies to Microsoft Word 2007 and 2010. You can discover a version of this tip for the older menu interface of Word here: Setting Tabular array Values to Three Decimal Places.

Author Bio

With more than fifty non-fiction books and numerous mag articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a figurer and publishing services company. Acquire more than about Allen...

More than FROM ALLEN

Maintaining Text Formatting in a Lookup

Desire to maintain the formatting used in one jail cell when you use formulas to reference that text in another cell? The answer ...

Discover More

Searching a Workbook past Default

When you display the Find tab of the Find and Supersede dialog box, y'all'll notice that any search, by default, volition be on ...

Notice More than

Irresolute the Ribbon's Size and Look

The Ribbon, while debatably handy, tin be downright difficult to apply for those with a sight impairment. Here are some ...

Discover More

choiexcerestint1952.blogspot.com

Source: https://wordribbon.tips.net/T011467_Setting_Table_Values_to_Three_Decimal_Places.html

Share this post