+ Reply to Thread
Results 1 to 2 of 2

Finding Text Format in Numeric Data

  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    49

    Finding Text Format in Numeric Data

    I have a listing with several thousand numeric entries but am getting a #VALUE return on a formula for one column which indicates there is a text entry. I have tried reformatting the column, copying formatting over from another column and visually scanning the column and still can't find cell with the text entry. Is there a way to find it other than what I have already tried?

    Thanks

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Finding Text Format in Numeric Data

    In a separate column use

    =ISNUMBER(A1)
    TRUE will denote numbers, FALSE non-numbers

    or

    =ISTEXT(A1)
    TRUE will denote TEXT

    Copy down and search for filter on TRUE/FALSE as the case maybe
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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. Replies: 9
    Last Post: 11-18-2013, 07:40 AM
  2. User form text box Numeric Format?
    By nighttrainrex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2011, 09:02 PM
  3. VBA format cell if is text and not a numeric value
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-13-2011, 06:20 PM
  4. [SOLVED] Changing cell format - for example text to numeric
    By sjrku in forum Excel General
    Replies: 3
    Last Post: 12-30-2005, 06:50 PM
  5. Change number (in text format) to numeric format
    By Pam in forum Excel General
    Replies: 5
    Last Post: 10-24-2005, 03:05 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