Re: combining integer and decimals

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Rick


"badongt" <badongt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:79B48D3F-F64A-46D8-BD67-97DD211B4F14@xxxxxxxxxxxxxxxx
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" <badongt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:371C14F4-ACD5-4714-B941-D59F54D4A79D@xxxxxxxxxxxxxxxx
> 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???



.

Relevant Pages

  • Re: combining integer and decimals
    ... How do you concatenate one cell? ... > 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 ...
    (microsoft.public.excel.programming)
  • Re: DisplayMember / ValueMember Question
    ... ComboBox can only be bound to a single value and single display column. ... > to concatenate multiple fields from a dataview for use as the value to ... > about a car, such as Make, Model, Year, etc. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: multiple fields from a combo box in a single field in related tabl
    ... primary key record, but assuming this is what you are doing: ... The drop-down combo box in the table will only display the first ... In the source query or Select Statement for the combo box, just concatenate ... combo box to display both fields from the table named "Powder". ...
    (microsoft.public.access.gettingstarted)
  • Re: display contents of preceeding cells consecutively
    ... i HAVE TRIED THE VARIOUS MOTHODS AS WELL AS =CONCATENATE ... (I TRIED TO SAY I FOUND OUT HOW AFTER POSTING BUT WAS TAKING FOREVER TO ... DISPLAY MY MESSAGE HERE ... I would like to display contents of preceeding cells consecutively ...
    (microsoft.public.excel.misc)
  • Excel Formula displays text of formula
    ... two cells =b2&b3 and it displayed the concatenated cells as it should. ... However, on worksheet 2, they tried to concatenate two cells again, but this ... it would not display the result, ... it quit working and went back to displaying the =c5&g5. ...
    (microsoft.public.excel.misc)