+ Reply to Thread
Results 1 to 2 of 2

formatting trick

  1. #1
    Registered User
    Join Date
    07-14-2015
    Location
    Stuttgart
    MS-Off Ver
    2013
    Posts
    75

    formatting trick

    Hello guys,

    i need to crack this problem on formatting. I think that the file attached is worthed more than 100 words.

    In a nutshell, I don't want to see, when the var. is minus, that weird -+ in the text column. I need the text column cause i have to upload that info in google maps.

    Attachment 500249

    Thanks in advance.


    Regards,
    AS

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,295

    Re: formatting trick

    Change:

    TEXT(C2,"+0%")

    to:

    IF(C2<0,"","+")&TEXT(C2,"0%")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run codes only in my PC or any other trick
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2016, 02:54 PM
  2. need drop down trick
    By chetanmehra1989 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-28-2012, 04:23 PM
  3. Lookup Question (Tricky)
    By usmanfarok in forum Excel General
    Replies: 1
    Last Post: 06-24-2012, 07:19 AM
  4. Formatting secondary axis bar chart overlap trick.
    By bnssteve in forum Excel General
    Replies: 4
    Last Post: 02-24-2012, 12:29 PM
  5. Tricky trick
    By Dário Sá in forum Excel General
    Replies: 1
    Last Post: 12-20-2011, 02:57 PM
  6. Help! Trick Question
    By Tanmay in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2010, 11:24 AM
  7. Macro box trick
    By danguyen_uci in forum Excel General
    Replies: 5
    Last Post: 05-13-2007, 02:09 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