Split a decimal figure
 

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

Split a decimal figure
 

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


"Jaleel" wrote:

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

Split a decimal figure
 

B1:
=INT(A1)

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

Regards,
Bernd

Split a decimal figure
 

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" wrote:

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

Split a decimal figure
 

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.
--
David Biddulph

"Jaleel" wrote in message
...
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" wrote:

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

Split a decimal figure
 

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

Regards,

Jaleel


"David Biddulph" wrote:

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.
--
David Biddulph

"Jaleel" wrote in message
...
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" wrote:

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

Split a decimal figure
 

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.
--
David Biddulph

"Jaleel" wrote in message
...
Thanks David. I got the solution when I multiplied the formula of Bernd
with
1000.

Regards,

Jaleel


"David Biddulph" wrote:

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.
--
David Biddulph

"Jaleel" wrote in message
...
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" wrote:

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

Split a decimal figure
 

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


"Jaleel" wrote in message
...
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" wrote:

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

Split a decimal figure
 

On Sun, 24 Aug 2008 22:38:01 -0700, Jaleel
wrote:

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

Split a decimal figure
 

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?

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

Split a decimal figure
 

On Tue, 26 Aug 2008 22:00:10 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

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?

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

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