Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split a decimal figure
B1:
=INT(A1) C1: =MOD(A1,1) or =A1-B1 Regards, Bernd |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal figure to minutes and seconds | Excel Discussion (Misc queries) | |||
How to split numbers and decimal in 2 columns | New Users to Excel | |||
Split number with decimal places into 2 columns | New Users to Excel | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
how to split one decimal pt integer off & to next columnin excel? | Excel Discussion (Misc queries) |