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.

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.

- 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)

2 Likes

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

Check out this thread.

2 Likes

thanks. I get it now.

3 Likes