openmolecules.org Forum: Functionality » Round numbers by decimal places?

Home » DataWarrior » Functionality » Round numbers by decimal places?

Show: Today's Messages :: Polls :: Message Navigator

Round numbers by decimal places? [message #2445]

Wed, 19 November 2025 22:23

Santora V
Messages: 11
Registered: March 2024

Junior Member

Is there a simple way to round numbers by decimal places rather than significant figures? I have a column with values that range from 1 to several digits (first list below), and I want to round them as shown in the 2nd list.

Perhaps a find and replace search?

Thanks!

1.1
11.2
11.6
101.2
101.6

Round to:
1
11
12
101
102

Report message to a moderator

[Message index]

		Round numbers by decimal places? By: Santora V on Wed, 19 November 2025 22:23
		Re: Round numbers by decimal places? By: amorrison on Thu, 20 November 2025 13:39
		Re: Round numbers by decimal places? By: Santora V on Fri, 21 November 2025 02:04
		Re: Round numbers by decimal places? By: nbehrnd on Sun, 07 December 2025 12:46
		Re: Round numbers by decimal places? By: thomas on Thu, 29 January 2026 13:38

Previous Topic:	Create structure image (idcode) from pasted SMILES
Next Topic:	Chemical Search Integration in PostgreSQL (SaaS Architecture)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Jun 13 05:00:07 CEST 2026

Total time taken to generate the page: 0.00536 seconds