PS....

I wrote:
The following should work in all cases:
B1: =INT(--A1)

Apparenty, "--" is unneeded with INT. INT(A1) should work for text as well
as numbers.

Sigh, I wish Excel were not so inconsistent, although it works in your favor
this time.


----- original message -----

"Joe User" <joeu2004 wrote in message
...
"Don Doan" wrote:
How do I do the same thing if there are 3 decimal places.. i.e 123.456
What happen if the format in cell A1 is a text? Can the splitting be
done?

The following should work in all cases:

B1: =INT(--A1)

B2: =A1 - B1

The formula in B1 does assume that if A1 is text, it is recognizable as a
number. If B1 results in a #VALUE! error, that assumption is wrong. In
that case, we may need to see exactly what text is in A1.


----- original message -----

"Don Doan" wrote in message
...
Hi there,
I have some questions kinda cirle the same issue...so just bear with me
he

If my cell A1 has number 1234.56, and I want cell B1 contains 1234 and
cell
B2 contains .56, How do I do that?

How do I do the same thing if there are 3 decimal places.. i.e 123.456

What happen if the format in cell A1 is a text? Can the splitting be
done?

Thanks.