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

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" <(E-Mail Removed)> wrote in message
news:371C14F4-ACD5-4714-B941-(E-Mail Removed)...
> 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???

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" <(E-Mail Removed)> wrote in message
> news:371C14F4-ACD5-4714-B941-(E-Mail Removed)...
> > 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???
>
>

I'm not sure what you mean... can you give some examples of calculations
that are giving you trouble?

Rick


"badongt" <(E-Mail Removed)> wrote in message
news:79B48D3F-F64A-46D8-BD67-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:371C14F4-ACD5-4714-B941-(E-Mail Removed)...
>> > 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???
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:371C14F4-ACD5-4714-B941-(E-Mail Removed)...
> > 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???
>
>

How do you concatenate one cell? Please show examples of what you have and
what you want when finished.

Rick


"badongt" <(E-Mail Removed)> wrote in message
news:9B52EA96-5855-4CAD-98C0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:371C14F4-ACD5-4714-B941-(E-Mail Removed)...
>> > 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???
>>
>>

On Fri, 13 Jun 2008 23:23:00 -0700, badongt <(E-Mail Removed)>
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