Split a decimal figure

J

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
 
A

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
 
J

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
 
D

David Biddulph

You haven't said what you want if there isn't a decimal point, but try
=IF(MOD(A1,1)=0,"",--RIGHT(A1,LEN(A1)-FIND(".",A1))) and modify to suit.
 
J

Jaleel

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

Regards,

Jaleel
 
D

David Biddulph

Yes, that's the easy way if you know that you've got 3 figures after the
decimal point. I was trying to be more general.
 
R

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
 
R

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
Click to expand...

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

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
Click to expand...

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
 
R

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
Click to expand...

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