+ Reply to Thread
Results 1 to 8 of 8

checking mistakes typing the number

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    checking mistakes typing the number

    I am trying to find accidentally typing the number. I've already given them the highlight in excel
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: checking mistakes typing the number

    You attach a workbook with over 11,000 rows by 2 columns. Some of these numbers are highlighted. Do you expect anyone to be able to determine WHY they're highlighted without you explaining the logic?

    Maybe they're supposed to be sequential.? Maybe they're supposed to be a certain length? Maybe any number of conditions??

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: checking mistakes typing the number

    Many times, that many mistakes in row is in writing and we do not know or take more time to find fault
    So I have given an example of how we can search for the number. It appears in a straight line coordinate.

  4. #4
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: checking mistakes typing the number

    So I have given an example of how we can search for the number
    You highlighted some numbers without explaining WHY they're highlighted.

  5. #5
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: checking mistakes typing the number

    because example of you know about that how could that mistake
    Last edited by sanju2323; 02-03-2016 at 09:35 AM.

  6. #6
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: checking mistakes typing the number

    The place where the error has occurred, it must match the number was around.

  7. #7
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: checking mistakes typing the number

    I'm sorry - I can't help.

  8. #8
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: checking mistakes typing the number

    No problem, but thank you for joining this topic

+ 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] Count the number of typing specific number in a cell
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-07-2015, 06:10 PM
  2. [SOLVED] displaying number of characters entered into a cell while typing
    By Alex Zbinden in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-13-2015, 05:22 PM
  3. Auto Populate quarters by just typing in the number of years
    By sugar_lips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2014, 09:31 AM
  4. Replies: 1
    Last Post: 06-17-2014, 02:11 AM
  5. How to count the number of characters while typing
    By Tam123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2013, 10:50 AM
  6. mistakes while multiplying
    By ivanplan in forum Excel General
    Replies: 1
    Last Post: 06-30-2011, 12:10 PM
  7. how to get a name just by typing a number?
    By bart in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 11:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1