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???

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???

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???

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???

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???

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???

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