Results 1 to 4 of 4

Thread: Comparing Numbers When One Is Text Format And The Other Is Number Numeric Format

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-05-2013, 07:53 AM #1
    Excel Fox
    Excel Fox is offline
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    In fact, it should be A2=IF(ISERROR(MATCH(""&B2,'TB Consolidation'!$B$1:$B$17,0)),"NEW","")

    OR

    Replace the "NEW" in the previous post to "OLD"
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook
    Reply With Quote Reply With Quote
  2. 04-05-2013, 08:24 AM #2
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14
    Thanks for the help, much appreciated


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-12-2023 at 12:59 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel Number Format: Indian Style Comma Separation
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 09-18-2013, 11:38 AM
  2. Macro - Import, Resize, Adjust Format, Position, Insert Text Box and Lines
    By CancerChemist in forum Word Help
    Replies: 3
    Last Post: 06-01-2013, 11:31 AM
  3. Trim Text after 3rd Underscore but retain format
    By trankim in forum Excel Help
    Replies: 4
    Last Post: 05-13-2012, 10:44 AM
  4. Format Cell To Convert Display Number As Billion / Million / Thousand
    By excel_learner in forum Excel Help
    Replies: 4
    Last Post: 03-10-2012, 07:15 PM
  5. Convert Text In YYYYMMDD Format To Date Format
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 02-28-2012, 12:04 AM

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
  •  

Forum Rules