+ Reply to Thread
Results 1 to 8 of 8

"is text and cannot be changed to a number."

  1. 10-19-2021, 06:03 AM #1
    robsonKun
    robsonKun is offline
    Registered User
    Join Date
    10-19-2021
    Location
    Poland
    MS-Off Ver
    google sheets
    Posts
    2

    "is text and cannot be changed to a number."

    Hello,

    In the first cell, everything goes in, and in the second cell, I get an error.


    "Parameter 1 of the MINUS function parameter requires a number." 0.352777 "is text and cannot be changed to a number.

    I think it's something related to a period / comma in a number. How to get it to calculate correctly.

    please help

    Thx

    excell 1.png
    excell 2.png
    Reply With QuoteRegister To Reply
  2. 10-19-2021, 06:06 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,444

    Re: "is text and cannot be changed to a number."

    Hi
    I don't know GSheets, but it seems your regional settings are non-US. Therefore the dot should be replaced with a comma. Does Gsheets have something like the SUBSTITUTE function?
    Reply With QuoteRegister To Reply
  3. 10-19-2021, 06:23 AM #3
    robsonKun
    robsonKun is offline
    Registered User
    Join Date
    10-19-2021
    Location
    Poland
    MS-Off Ver
    google sheets
    Posts
    2

    is text and cannot be changed to a number

    Hi

    I have tried to change regional setting for GB, next for US but that wasn't working. Im from Poland.

    I import data. C2 is =IMPORTDATA("link")
    D2 is working I mean =(C2-B2)/B2

    But next cell not idk why
    Reply With QuoteRegister To Reply
  4. 10-19-2021, 08:51 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,444

    Re: "is text and cannot be changed to a number."

    Changing regional settings to US should change but you have to multiply the value by 1 or add 0 to change text to number ( IF it works like Excel)
    Reply With QuoteRegister To Reply
  5. 10-19-2021, 09:00 AM #5
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: "is text and cannot be changed to a number." 

    Please Login or Register  to view this content.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  6. 10-19-2021, 09:03 AM #6
    Flyboy65
    Flyboy65 is offline
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: "is text and cannot be changed to a number."

    Hi,

    The first thing I would check is to make sure the symbol is correct. I used other symbols (BTC, USDC, XRP etc) and they all seemed to work using your formula.
    Reply With QuoteRegister To Reply
  7. 10-19-2021, 09:06 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,288

    Re: "is text and cannot be changed to a number."

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do it for you today: https://www.mrexcel.com/board/thread...umber.1185077/)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  8. 10-25-2021, 03:59 PM #8
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: "is text and cannot be changed to a number."

    i have created a dummy file, and set the Spreadsheet Settings locale to Poland,
    then using manually entered data in cell B3, and the same importdata formula as in your screenshot, it automatically uses the same currency without an issue.

    Screen Shot 2021-10-26 at 2.52.29 am.png

    so, try dragging cell C2 down to cell C3, then edit the formula as necessary
    Last edited by janmorris; 10-25-2021 at 04:02 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Not Work If Changed Text "CLUE"
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-30-2019, 03:43 AM
  2. [SOLVED] strange problem: dot "." changed to coma "," but it schuldnt have been
    By kmeld in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2013, 04:00 AM
  3. [SOLVED] Re: macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 07:14 AM
  4. [SOLVED] macro for converting number stored as "text" (or preceeded with ') to "number" formatting
    By markx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2006, 10:20 AM
  5. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 AM
  6. [SOLVED] convert a number in Excel from numeric to text, i.e. "1" to "one"
    By buenavisionpaul in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1