Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    concatenate with format (2000 sr 1)

    i would want to concatenate this cells:
    in A1 have 4500
    in B1 have 000250 (with this format number #000000)
    when i concatenate in C1 have 4500-250 (=SE(A1>0;CONCATENA(A1;"-";B1);""))

    I would want to mintain the formt number in B1...
    i want this 4500-000250

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: concatenate with format (2000 sr 1)

    Try this:
    <code>
    =A1&"-"&TEXT(B1;"000000")
    </code>
    (I assume that you have the ; as list separator)

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: concatenate with format (2000 sr 1)

    TKS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •