Results 1 to 3 of 3

how to get concatenate only to show 2 decimals

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    how to get concatenate only to show 2 decimals

    My formula is


    =CONCATENATE(AU4,AU3,AF3,AU3,AF4,AU3,U4,U5,AU3,V4,V5,AU3,W4,W5,AU3,X4,X5,AU3,Y4,Y5,AU3,Z4,Z5,AU3,AA4,AA5,AU3,AB4,AB5)


    answer comes out as


    Survey / MDC TEXAS / OMAHA 11-2 2HM / Depth:3413 / INC:6.83555 / AZM:272.31555 / TVD:3409.195555 / N/S-1.945555 / E/W-39.47555 / VS-10.69555 / DLS:1.35////


    how can i get it too


    Survey / MDC TEXAS / OMAHA 11-2 2HM / Depth:3413 / INC:6.83 / AZM:272.31 / TVD:3409.19 / N/S-1.94 / E/W-39.47 / VS-10.69 / DLS:1.35


    any help would be great
    Last edited by AliGW; 06-17-2018 at 08:23 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Hide decimals through =CONCATENATE
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-25-2016, 11:37 AM
  2. [SOLVED] How to concatenate numbers with 2 fixed decimals
    By Bas5742 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-13-2016, 06:40 AM
  3. Removing decimals fron concatenate formuls
    By deanblew in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2016, 09:12 AM
  4. Replies: 2
    Last Post: 02-13-2015, 07:36 AM
  5. [SOLVED] How to Concatenate two cell with decimals
    By sharathnarayanan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2014, 02:53 PM
  6. Fixied Decimals with CONCATENATE
    By TimmyK in forum Excel General
    Replies: 2
    Last Post: 06-11-2009, 11:40 AM
  7. CONCATENATE with decimals, convert to fractions
    By rberger909 in forum Excel General
    Replies: 5
    Last Post: 12-05-2006, 11:33 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1