+ Reply to Thread
Results 1 to 5 of 5

Google Sheets - ISNUMBER() - Shows FALSE for cell formatted as number

  1. #1
    Registered User
    Join Date
    03-25-2022
    Location
    Munich
    MS-Off Ver
    2019
    Posts
    5

    Google Sheets - ISNUMBER() - Shows FALSE for cell formatted as number

    Hello!

    Issue:
    • Cell C1 fetches a number from a web page via IMPORTXML.
    • Cell B1 refers to it (=C1).
    • B1 and C1 are formatted as number and also display numbers.

    However, ISNUMBER for both cells is FALSE and the shown decimals in B1 and C1 cannot be changed. Even if I copy the format of a cell D1, where ISNUMBER returns TRUE, to B1 and C1, it remains FALSE there.

    What could be the reason if a cell is formatted as a number, a number is visible there (via formula) and yet ISNUMBER returns FALSE?

    Thanks in advance for your help!
    Last edited by Hans Huber; 03-30-2022 at 07:08 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,585

    Re: Google Sheets - ISNUMBER() - Shows FALSE for cell formatted as number

    This happens with text "looking like a number".
    Formatting is just a way it shows things to the world. As well in GS as XL text is left aligned in cells, real numbers right-aligned ( without manual alignment)
    Select your "number" - Data - Text to columns ( or equivalent) - OK The number should now be right-aligned
    There are other techniques available

  3. #3
    Registered User
    Join Date
    03-25-2022
    Location
    Munich
    MS-Off Ver
    2019
    Posts
    5

    Re: Google Sheets - ISNUMBER() - Shows FALSE for cell formatted as number

    Thank you!

    I'm not quite sure if I got you right.
    "Data - Text to columns" results in a second column and for example "1,62" in Cell C1 is then splitted in "1" in Cell C1 and "62" in Cell D1.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,230

    Re: Google Sheets - ISNUMBER() - Shows FALSE for cell formatted as number

    Try changing the formula in B1 to =C1+0
    Rory

  5. #5
    Registered User
    Join Date
    03-25-2022
    Location
    Munich
    MS-Off Ver
    2019
    Posts
    5

    Thumbs up Re: Google Sheets - ISNUMBER() - Shows FALSE for cell formatted as number

    Perfect, this works.

    Thanks a lot!!!

+ 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] ISNUMBER in conditional formatting that contain certain text shows true
    By chaiyya345 in forum Excel General
    Replies: 6
    Last Post: 02-11-2022, 04:11 AM
  2. [SOLVED] Google sheet: Number not formatted/maybe error in formula
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-28-2019, 05:28 AM
  3. [SOLVED] Formula shows as True, should shows as False
    By Eduards in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-07-2018, 12:11 PM
  4. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  5. [SOLVED] ISNUMBER = FALSE, how do I convert to number?
    By BenCrockett in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-18-2013, 02:41 PM
  6. Replies: 4
    Last Post: 04-12-2013, 01:17 PM
  7. [SOLVED] Shows empty cell instead of FALSE
    By Anka in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-20-2012, 03:24 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