Previous Topic Next Topic

Whole Numbers and Decimals

Closed
ConcernedMathStudent Posts 1 Registration date Saturday 3 October 2015 Status Member Last seen 3 October 2015 - 3 Oct 2015 à 17:13
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 5 Oct 2015 à 11:15
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
5 Oct 2015 à 11:15
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