Path: csiph.com!usenet.pasdenom.info!goblin2!goblin.stu.neva.ru!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.027 X-Spam-Evidence: '*H*': 0.95; '*S*': 0.00; 'assign': 0.07; 'float': 0.07; 'subject:two': 0.07; 'string': 0.09; 'cc:addr:python-list': 0.11; 'assume': 0.14; '>>': 0.16; 'aligned.': 0.16; 'trying': 0.19; '>>>': 0.22; 'preferred': 0.22; 'cc:addr:python.org': 0.22; '>>>': 0.24; '(a)': 0.24; 'cc:2**0': 0.24; 'cc:no real name:2**0': 0.24; 'header:In-Reply- To:1': 0.27; 'function': 0.29; 'message-id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'text': 0.33; 'url:python': 0.33; 'but': 0.35; 'received:google.com': 0.35; 'url:listinfo': 0.36; 'method': 0.36; 'url:org': 0.36; 'from:addr:googlemail.com': 0.38; 'skip:& 20': 0.39; 'url:mail': 0.40; 'subject: & ': 0.68; '8bit%:100': 0.72; '\xc2\xa0\xc2\xa0': 0.74; 'br,': 0.84; 'skip:\xe0 20': 0.84; 'sri': 0.84; 'subject:round': 0.84 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:cc:content-type; bh=a9CgeISnk0iwAO0QwokcvsEO28RiBXQXWdbOFLGdhPs=; b=d4lhaBr3bWJRjDj2bzU6476KNEPRFDHdK9B3Z77SQnMI+iE8NFw06XFKlgRzVhfIX9 JH0vRLmWyUUshtC+ZNlO6qgXaC33cL1YyFlNhTOoZa1EcJXufn19ShQJUxvL4UBopV4L BrK3dMtGRh5Tbxx2eavwGt8cymfAT+EcBlt4O5zUVx1/opRMGF+OWH2wVYsSBnbIHZ5F /ieYYrdC3E7gNmxYdyrtuEuR1+0CipTc83Dxs7USwLcnYPtaCwmADz1qWYiqgS5UPR7T f2Dp2nRyUeinpFyRif6mdYNDFJdlUrGZHTQpTPtTrvZx3h+bo91wCSUHfj2r4P6AXhkf xLWA== X-Received: by 10.112.143.129 with SMTP id se1mr2546380lbb.120.1364635741709; Sat, 30 Mar 2013 02:29:01 -0700 (PDT) MIME-Version: 1.0 In-Reply-To: <515699DB.8060104@amachu.me> References: <515699DB.8060104@amachu.me> From: Roland Mueller Date: Sat, 30 Mar 2013 11:28:41 +0200 Subject: Re: round off to two decimal & return float To: =?UTF-8?B?4K6G4K6u4K6+4K6a4K+N4K6a4K+B?= Content-Type: multipart/alternative; boundary=089e0116070ea1eb6904d9210416 Cc: python-list@python.org X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 114 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1364635750 news.xs4all.nl 6865 [2001:888:2000:d::a6]:46862 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:42328 --089e0116070ea1eb6904d9210416 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, 2013/3/30 =E0=AE=86=E0=AE=AE=E0=AE=BE=E0=AE=9A=E0=AF=8D=E0=AE=9A=E0=AF=81 <= amachu@amachu.me> > Consider the scenario, > > >> a =3D 10 > >> "{0:.2f}".format(a) > '10.00' > > This returns a string 10.00. But what is the preferred method to retain > 10.0 (float) as 10.00 (float)? > > I assume you have a numeric value a and want to have a float with 2 decimals. This can be achieved with the function round(): >>> a =3D 10 >>> type(a) >>> a =3D round(10,2) >>> type (a) >>> a 10.0 BR, Roland > I am trying to assign the value to a cell of a spreadsheet, using > python-xlwt. I would like to have 10.00 as the value that is right > aligned. With text it is left aligned. > > -- > > Sri Ramadoss M > > -- > http://mail.python.org/mailman/listinfo/python-list > --089e0116070ea1eb6904d9210416 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 SGVsbG8sPGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+MjAxMy8zLzMwIOCuhuCuruCu vuCumuCvjeCumuCvgSA8c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzphbWFjaHVA YW1hY2h1Lm1lIiB0YXJnZXQ9Il9ibGFuayI+YW1hY2h1QGFtYWNodS5tZTwvYT4mZ3Q7PC9zcGFu Pjxicj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAg LjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij4NCg0KQ29u c2lkZXIgdGhlIHNjZW5hcmlvLDxicj4NCjxicj4NCiZndDsmZ3Q7IGEgPSAxMDxicj4NCiZndDsm Z3Q7ICZxdW90O3swOi4yZn0mcXVvdDsuZm9ybWF0KGEpPGJyPg0KJiMzOTsxMC4wMCYjMzk7PGJy Pg0KPGJyPg0KVGhpcyByZXR1cm5zIGEgc3RyaW5nIDEwLjAwLiBCdXQgd2hhdCBpcyB0aGUgcHJl ZmVycmVkIG1ldGhvZCB0byByZXRhaW48YnI+DQoxMC4wIChmbG9hdCkgYXMgMTAuMDAgKGZsb2F0 KT88YnI+DQo8YnI+PC9ibG9ja3F1b3RlPjxkaXY+SSBhc3N1bWUgeW91IGhhdmUgYSBudW1lcmlj IHZhbHVlIGEgYW5kIHdhbnQgdG8gaGF2ZSBhIGZsb2F0IHdpdGggMiBkZWNpbWFscy4gVGhpcyBj YW4gYmUgYWNoaWV2ZWQgd2l0aCB0aGUgZnVuY3Rpb24gcm91bmQoKTrCoDwvZGl2PjxkaXY+PGJy PjwvZGl2PjxkaXY+Jmd0OyZndDsmZ3Q7IGEgPSAxMCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oDwvZGl2Pg0KDQo8ZGl2PiZndDsmZ3Q7Jmd0OyB0eXBlKGEpPC9kaXY+PGRpdj4mbHQ7dHlwZSAm IzM5O2ludCYjMzk7Jmd0OzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Jmd0OyZndDsmZ3Q7IGEg PSByb3VuZCgxMCwyKSDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoMKgPC9kaXY+DQoNCjxkaXY+PGJyPjwvZGl2PjxkaXY+ Jmd0OyZndDsmZ3Q7IHR5cGUgKGEpIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPC9kaXY+PGRpdj4N CiZsdDt0eXBlICYjMzk7ZmxvYXQmIzM5OyZndDsgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA8L2Rpdj4N CjxkaXY+PGRpdj4mZ3Q7Jmd0OyZndDsgYSDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oMKgPC9kaXY+PGRpdj4xMC4wIMKgPC9kaXY+DQoNCjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+ QlIsPC9kaXY+PGRpdj5Sb2xhbmQ8L2Rpdj48ZGl2PsKgPC9kaXY+PGJsb2NrcXVvdGUgY2xhc3M9 ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNj Y2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleCI+DQpJIGFtIHRyeWluZyB0byBhc3NpZ24gdGhlIHZh bHVlIHRvIGEgY2VsbCBvZiBhIHNwcmVhZHNoZWV0LCB1c2luZzxicj4NCnB5dGhvbi14bHd0LiBJ IHdvdWxkIGxpa2UgdG8gaGF2ZSAxMC4wMCBhcyB0aGUgdmFsdWUgdGhhdCBpcyByaWdodDxicj4N CmFsaWduZWQuIFdpdGggdGV4dCBpdCBpcyBsZWZ0IGFsaWduZWQuPGJyPg0KPGJyPg0KLS08YnI+ DQo8YnI+DQpTcmkgUmFtYWRvc3MgTTxicj4NCjxzcGFuIGNsYXNzPSJIT0VuWmIiPjxmb250IGNv bG9yPSIjODg4ODg4Ij48YnI+DQotLTxicj4NCjxhIGhyZWY9Imh0dHA6Ly9tYWlsLnB5dGhvbi5v cmcvbWFpbG1hbi9saXN0aW5mby9weXRob24tbGlzdCIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly9t YWlsLnB5dGhvbi5vcmcvbWFpbG1hbi9saXN0aW5mby9weXRob24tbGlzdDwvYT48YnI+DQo8L2Zv bnQ+PC9zcGFuPjwvYmxvY2txdW90ZT48L2Rpdj48YnI+DQo= --089e0116070ea1eb6904d9210416--