Previous Topic Next Topic

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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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