Separate the decimal number

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.

  1. Create a math column to set the precision to 1. (6.7877 -> 6)
  2. Create a template column and replace any letter with that math column (this converts the number to a string: 6 -> β€œ6” )
  3. 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