Posted to microsoft.public.excel.programming

external usenet poster

Posts: 62

Truncate

How can I truncate the values in Col A so the results are what's 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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Truncate	GWC	Excel Programming	1	December 16th 13 06:35 PM
Truncate	Elizabeth	Excel Discussion (Misc queries)	4	November 18th 09 09:50 PM
How do you truncate 2.22 to just 0.22?	Crackles McFarly	Excel Worksheet Functions	6	September 5th 07 01:14 AM
Truncate/Mod	Abode	Excel Programming	9	May 19th 06 03:30 AM
Truncate	Steven	Excel Programming	11	April 20th 04 12:11 PM

All times are GMT +1. The time now is 12:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us