2 decimal places, how?

Jon Yates

Guest

Posts: n/a

4th Aug 2003

How do I get a value to output as 2 decimal places.

I have 3 columns Target, Actual and Varience. When I do a
Target of 4.60 an Actual of 5.20 I get a Varience of
0.600000000000001. How do I get this to be 0.60? All the
values are declard as doubles.

Thanks all,

Jon

« Re: Print HTML page | Re: DateTime & Regional Setting differences »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text box formatted to General Number with 2 decimal places NOTallowing the decimal place.	p-rat	Microsoft Access Form Coding	3	14th Jan 2008 05:20 PM
Subtracting two 2-decimal place numbers gives result 13-decimal places?	tsdutcher@earthlink.net	Microsoft Excel Worksheet Functions	5	12th Mar 2007 10:38 PM
Re: conditionally round decimal numbers from 8 places to 6 places	pietlinden@hotmail.com	Microsoft Access Queries	0	16th Jan 2007 07:09 PM
decimal places in acces more than 2 places when importing an excel	=?Utf-8?B?cm9iZXJ0cm9iZXJ0cm9iZXJ0cm9iZXJ0?=	Microsoft Outlook Discussion	2	28th Sep 2005 04:41 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.	=?Utf-8?B?U1VLWUtJVFRZ?=	Microsoft Excel Misc	3	6th Jul 2005 01:50 PM