Truncate
 

How can I truncate the values in Col A so the results are as shown in Col B:

A B
1348.63 134.86
1174.14 117.41
1298.76 129.87
768.33 76.83
742.99 74.29
14.72 1.47
0.09 .00
26.03 2.60
26.28 2.62
26.70 2.67
3.66 .36
3.70 .37
0.68 .06
0.69 .06
186.62 18.66
374.43 37.44
394.16 39.41
402.12 40.21
403.57 40.35
417.91 41.79
322.45 32.24
328.36 32.83
334.73 33.47
341.26 34.12
27272.11 2727.21
50.79 5.07
147.12 14.71

Truncate
 

Enter 10 in an empty cell.

Copy then select your data cells and paste specialdivideokesc

Format column A to 2 dp.

Gord

On Mon, 16 Dec 2013 09:26:13 -0800 (PST), GWC
wrote:

How can I truncate the values in Col A so the results are as shown in Col B:

A B
1348.63 134.86
1174.14 117.41
1298.76 129.87
768.33 76.83
742.99 74.29
14.72 1.47
0.09 .00
26.03 2.60
26.28 2.62
26.70 2.67
3.66 .36
3.70 .37
0.68 .06
0.69 .06
186.62 18.66
374.43 37.44
394.16 39.41
402.12 40.21
403.57 40.35
417.91 41.79
322.45 32.24
328.36 32.83
334.73 33.47
341.26 34.12
27272.11 2727.21
50.79 5.07
147.12 14.71