Results 1 to 2 of 2

Using & to connect cells without changing value format

Threaded View

Mr Stern 2 Using & to connect cells... 09-08-2020, 05:54 AM
Shareez Saleem Re: Using & to connect cells... 09-08-2020, 06:09 AM
  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dublin
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    22

    Using & to connect cells without changing value format

    Hi,

    So I am working on a report where I am connecting results into simple sentences.
    I tend to do this using various 'if' functions along with some calculations.

    However where I run into problems is in the formatting of values in this.
    I am looking to keep values indicated by the thousand, but when I put into an & it breaks up the format.

    E.g.

    Current Mo 228,512
    Prior Mo 252,608
    difference 24
    Total NFI has decreased vs prior month by

    Total NFI has decreased vs prior month by 24096.0400000003k

    What I am looking for is the final wording to be as below

    Total NFI has decreased vs prior month by 24k


    Formulas indicated below.
    Current Mo 228511.78
    Prior Mo 252607.82
    difference =ABS(O19-O20)
    =IF(O20-O19>500,"Total NFI has decreased vs prior month by ",IF(O19-O20>500,"Total NFI has increased vs prior month by ","Total NFI is in line with prior month"))

    I have formatted the cells to show values as 000's but it reverts back when & is used.

    Any thoughts on how to fix this?
    Happy to work with other formulas as well.

    Thanks,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing color format in cells based on 3 range values in a different column cells.
    By konkonmike in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-08-2019, 08:11 AM
  2. Changing Cell format based on another cells format.
    By MrStevie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2017, 03:02 PM
  3. [SOLVED] Changing date format in different cells
    By Omkariias in forum Excel General
    Replies: 12
    Last Post: 09-17-2014, 07:19 AM
  4. Preventing Cells from Changing Format
    By wmfinance in forum Excel General
    Replies: 2
    Last Post: 10-05-2010, 12:59 PM
  5. [SOLVED] Changing format of cells
    By Viktor Ygdorff in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2006, 07:25 AM
  6. Changing format of cells
    By RobH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2006, 07:50 AM
  7. Changing Cells format using VBA
    By Amir in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2005, 08:05 AM

Tags for this Thread

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