| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining integer and decimals
Numbers show an extra zero "0" before the decimal point that changes the
display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combining integer and decimals
I'm not really "satisfied" with this one, but it does work. If your two
numbers are in A1 and B1... =IF(LEFT(A1,2)="0.",MID(A1,2,99),A1)&IF(LEFT(B1,2) ="0.",MID(B1,2,99),B1) Now the above is a completely general solution; however, if A1 **always** contains an integer, the formula can be simplified... =A1&IF(LEFT(B1,2)="0.",MID(B1,2,99),B1) Rick "badongt" wrote in message ... Numbers show an extra zero "0" before the decimal point that changes the display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combining integer and decimals
What if the integers digits changes from 2 to 3 and vice versa?
"Rick Rothstein (MVP - VB)" wrote: I'm not really "satisfied" with this one, but it does work. If your two numbers are in A1 and B1... =IF(LEFT(A1,2)="0.",MID(A1,2,99),A1)&IF(LEFT(B1,2) ="0.",MID(B1,2,99),B1) Now the above is a completely general solution; however, if A1 **always** contains an integer, the formula can be simplified... =A1&IF(LEFT(B1,2)="0.",MID(B1,2,99),B1) Rick "badongt" wrote in message ... Numbers show an extra zero "0" before the decimal point that changes the display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combining integer and decimals
I'm not sure what you mean... can you give some examples of calculations
that are giving you trouble? Rick "badongt" wrote in message ... What if the integers digits changes from 2 to 3 and vice versa? "Rick Rothstein (MVP - VB)" wrote: I'm not really "satisfied" with this one, but it does work. If your two numbers are in A1 and B1... =IF(LEFT(A1,2)="0.",MID(A1,2,99),A1)&IF(LEFT(B1,2) ="0.",MID(B1,2,99),B1) Now the above is a completely general solution; however, if A1 **always** contains an integer, the formula can be simplified... =A1&IF(LEFT(B1,2)="0.",MID(B1,2,99),B1) Rick "badongt" wrote in message ... Numbers show an extra zero "0" before the decimal point that changes the display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combining integer and decimals
Thanks for the quick reply Rick, i also would like to ask what if the numbers
(both integer and decimal) are in 1 cell..? "Rick Rothstein (MVP - VB)" wrote: I'm not really "satisfied" with this one, but it does work. If your two numbers are in A1 and B1... =IF(LEFT(A1,2)="0.",MID(A1,2,99),A1)&IF(LEFT(B1,2) ="0.",MID(B1,2,99),B1) Now the above is a completely general solution; however, if A1 **always** contains an integer, the formula can be simplified... =A1&IF(LEFT(B1,2)="0.",MID(B1,2,99),B1) Rick "badongt" wrote in message ... Numbers show an extra zero "0" before the decimal point that changes the display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combining integer and decimals
How do you concatenate one cell? Please show examples of what you have and
what you want when finished. Rick "badongt" wrote in message ... Thanks for the quick reply Rick, i also would like to ask what if the numbers (both integer and decimal) are in 1 cell..? "Rick Rothstein (MVP - VB)" wrote: I'm not really "satisfied" with this one, but it does work. If your two numbers are in A1 and B1... =IF(LEFT(A1,2)="0.",MID(A1,2,99),A1)&IF(LEFT(B1,2) ="0.",MID(B1,2,99),B1) Now the above is a completely general solution; however, if A1 **always** contains an integer, the formula can be simplified... =A1&IF(LEFT(B1,2)="0.",MID(B1,2,99),B1) Rick "badongt" wrote in message ... Numbers show an extra zero "0" before the decimal point that changes the display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combining integer and decimals
On Fri, 13 Jun 2008 23:23:00 -0700, badongt
wrote: Numbers show an extra zero "0" before the decimal point that changes the display value whenever i do a concatenate with an integer..Is there a way to remove that extra "0" so it would display the concatenated value properly??? Ordinarily one would add numbers. Can you give an example of your source data, and your desired results? --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count digits before decimals and after decimals | Excel Worksheet Functions | |||
| How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
| Decimals Constant to 0.50 or Nearest Integer | Excel Worksheet Functions | |||
| Numeric formatting: decimals and no decimals | Excel Programming | |||
| Dim i,j,k As Integer | Excel Programming | |||
Linear Mode
