Split a decimal figure

[Jaleel]

Hi,

I have a figure in A1. For example, 255.875

Is it possible to bring 255 in B1 and 875 in C1 as numbers, not text?

Regards,

Jaleel

 

[akphidelt]

You can use text to columns

Highlight the data go to

Data->Text-to-Columns

Click on Next, then click the "Other" box and type in a period

 

[Bernd P]

B1:
=INT(A1)

C1:
=MOD(A1,1)
or
=A1-B1

Regards,
Bernd

 

[Jaleel]

Hi,

Thanks to both of you. I am working on a tender document and so text column
exercise cannot be done. However, the formula of Bernd is practical. Cell
B1 is OK. But in C1 I am not getting the desired 855. It shows 0.850. Any
other options?

Regards,

Jaleel

 

[Jaleel]

Thanks David. I got the solution when I multiplied the formula of Bernd with
1000.

Regards,

Jaleel

 

[Rick Rothstein \(MVP - VB\)]

Here is another way...

A1: 255.875
B1: =INT(A1)
C1: =IF(ISNUMBER(FIND(".",A1)),--SUBSTITUTE(A1,B1&".","",1),0)

This will work no matter how many digits follow the decimal point.

Rick

 

[Ron Rosenfeld]

Hi,

I have a figure in A1. For example, 255.875

Is it possible to bring 255 in B1 and 875 in C1 as numbers, not text?

Regards,

Jaleel

What do you want to show, in C1, if A1: 255.012
--ron

 

[Rick Rothstein \(MVP - VB\)]

I have a figure in A1. For example, 255.875

What do you want to show, in C1, if A1: 255.012

Great question!

Jaleel... just so you don't miss the point, Ron is asking about 255.012 in
comparison to 255.12 (or even 255.0012).

Rick

 

[Ron Rosenfeld]

Great question!

Jaleel... just so you don't miss the point, Ron is asking about 255.012 in
comparison to 255.12 (or even 255.0012).

Rick

Thanks for clarifying the point I was trying to make, Rick.
--ron