Whole Numbers and Decimals

Closed
Report
Posts
1
Registration date
Saturday October 3, 2015
Status
Member
Last seen
October 3, 2015
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Forgive me if I was an anonymous user who had only a single question to ask after searching the internet for hours, and didn't know there were courtesy rules to this forum.

I hope I wasn't too rude earlier, but I still need help. As I said I need to separate my whole numbers and decimals (In an array of rows and column put together), and have them in separate rows and columns.

If you know how to, I would be very appreciative and give my sincerest thanks to whomever can supply me with an answer.

Please, and thank you for all that you do.
-ConcernedMathStudent

1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
ConcernedMathStudent, Good morning.

Welcome to this forum!

Suppose:

A1 = 10,44

B1 --> FORMULA --> INT(A1)
C1 --> FORMULA --> A1-B1

THEN...
B1 = 10
C1 = 0,44

Remember that values at B and C columns are formulas.
If you want PURE values at these columns do:
Select these cells
Copy
Special paste: VALUE

Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão