Whole Numbers and Decimals

Closed
ConcernedMathStudent
Posts
1
Registration date
Saturday October 3, 2015
Status
Member
Last seen
October 3, 2015
- Oct 3, 2015 at 05:13 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Oct 5, 2015 at 11:15 AM
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
Related:

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Oct 5, 2015 at 11:15 AM
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
0