Hi. Is there a way to separate the decimal number. example : Number Column 1 Column 2 6.7877 6 0.7877 using add glide column function. Not using spreadsheet function Thanks.

Check out this thread. [image] TRUNC function in Math column or send results to sheet? Feature Requests Check out the concept I made here in the Trunc test tab. What I did behind the scenes, assuming Dave only needs positive numbers as inputs. [image] A math column &…

Create a math column to set the precision to 1. (6.7877 -> 6) Create a template column and replace any letter with that math column (this converts the number to a string: 6 -> “6” ) Create a math column to subtract the string column from the original column (6.7877 - “6” = 0.7877)

I try this, but i don’t get 6 but I get 7

Separate the decimal number

Ask for Help

Jeff_Hager September 30, 2020, 1:23pm 5

Check out this thread.

Topic		Replies	Views
🤔 How to: Remove .00 from Math column numbers without rounding up/down with "Precision 1"? (w/ pic) Ask for Help	21	581	May 13, 2024
TRUNC function in Math column or send results to sheet? Feature Requests	10	1799	August 30, 2020
Decimal point changes to a comma Ask for Help	4	141	May 20, 2024
Can we put seperation ' into numbers? Ask for Help	10	402	October 11, 2022
Decimal limit (in formula) Ask for Help	3	771	October 29, 2020

Separate the decimal number

Related topics